WampServer

I installed Wampserver2.4-x86 in my laptop (windows 7 32 bit). Its successfully installed and working. But when i tried to create a database I am getting error "No Privileges". I was not asked to enter any password during installation. But Its asking username & password. Please help to resolve the Issue. How to get the privilege to create the database.

What are you using to try and create a database?

What is asking for a username and password?

Hi there.

I have the same problem.

After clicking on Database, there is a red cross telling me "no privileges". I was not given the opportunity to provide a username or password or even to add privileges.

I used to use older versions of WAMP which worked 100% where I could add databases from the home page. I know it is possible that I missed something during installation. During installation I was only asked to provide SMTP settings and my e-mail address.

Please help.

Deon

This may sound silly, but lets start with the easy stuff.

Can you refresh your browsers cache, to do that open the browser and press F5.


Ohh, I see you have downloaded the WampServer 2.4, things changed a little in phpmyadmin 4.0.4 which is what comes with that version.

As you say it should be throwing a login dialog. The userid/password is any mysql user/password that exists in MySQL. Untill you create your own that should be

userid = root
password = NOTHING ( leave it blank )

Does that work?



Edited 1 time(s). Last edit at 07/01/2013 03:33PM by RiggsFolly.

Click the 'Change Password' link,



You will then get a new dialog, Enter your password here, then click Go



REMEMBER WHAT YOU CHANGE IT TO. !!!!!!!!!!!!

Thank you.
I have in the mean time used an older version which is working fine. I will retry at a later stage.
I have tried to change the password but then I also got an error message; I cannot remember what it was.

Thank you anyway.
Deon

Deon,

Re: Then I get error message.


Yes thats right. Once you change the password as above, the next time you click on anything your logon is invalid ( because you logged in using root and no password and now root has a password).

You should be thrown to the login screen again, just use root again but with the newly created password.

I am having the same problem. No privileges, means I can't create a database.

I can't even change my password I get a #1133 error message.

So I tried adding a username and password in the config file but then I couldn't log in phpMyAdmin

BUMP!

Lordy Lordy,


Can you check the following locations for the following files please.

C:\Windows\my.ini 
C:\Windows\my.cnf 
C:\my.ini C:\my.cnf

If any of them exist please delete them.

In fact to be super sure, if you find a my.ini or my.cnf file outside of the c:\wamp\bin\mysql folder structure please delete them.
The my.ini should only exists within the wamp folder structure, and my.cnf should not exists at all.


Sometimes when you have attempted to install MySQL some other way this file get placed in the Lazy locations and gets used in preference to the one supplied by wamp. Also some PC builders seem to have this file loaded as part of the default build, for some obsquire reason.

Do you login with Root (capital) or root (no capital). That was it for me :-)

'root' Lowercase and no quotes

create new user with total rights via sqlbuddy and try login in phpmyadmin under new user loginname and p/w.

SQlBuddy can be easier to use than phpmyadmin, you can access it at [127.0.0.1]. the default username is root and there is no password.

ClearModule - Free PHP Training - [clearmodule.com]

Thank you very much for this very simple answer to this (apparently difficult) question.

Quote

RiggsFolly :: type in username --> root leave password blank hit go

= full access
cheers from this newbie to wampserver!

Same problem

Did reading the above solve it?

Easy fix:

1. Find the "Log Out icon" top left next to the "Home" icon in PhpMyAdmin
2. Logout
3. Login using username "root" and password "" (blank).

You can now create databases or anything else you need to do. You logged in with "root" privileges!

Thank you very much! #Solution

NativeRadio Wrote:
-------------------------------------------------------
> Easy fix:
>
> 1. Find the "Log Out icon" top left next to the
> "Home" icon in PhpMyAdmin
> 2. Logout
> 3. Login using username "root" and password ""
> (blank).
>
> You can now create databases or anything else you
> need to do. You logged in with "root" privileges!


Thank you very much! #Solution