I was using phpmyadmin(in Wamp) without a password for root. I thought to set a password for root and goto Privileges page and set a password for root. Now whenever I go to localhost/phpmyadmin page it gives me the following error.

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected 
the connection.

You should check the host, username and password in your configuration 
and make sure that they correspond to the information given by the 
administrator of the MySQL server. 

I don't know that what is the problem. It is not showing me a login type page to enter a username and password. Any idea that what is the problem ?



This is a configuration issue. To get phpMyAdmin's username / password login, you need to set the right Auth setting in your config.inc.php, probably "cookie":

auth_type = 'cookie'

prompts for a MySQL username and password in a friendly HTML form. This is also the only way by which one can log in to an arbitrary server (if $cfg['AllowArbitraryServer'] is enabled). Cookie is good for most installations (default in pma 3.1+), it provides security over config and allows multiple users to use the same phpMyAdmin installation. For IIS users, cookie is often easier to configure than http.


that's not the login/password to PHPMyAdmin, but it requires login / pwd for MySQL in config file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.