• Content
  • Comments (0)
  • Related articles
Jun
04
2011

phpMyAdmin access denied under Wamp Server Saturday, 4 June 2011

How to solve #1045 – Access denied for user ‘root’@’localhost’ (using password: NO). For those who chose to add password to access MySQL and get the following error:

Welcome to phpMyAdmin

Error
MySQL said:

#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.

The solution is:

  • go to c:\wamp\apps\phpmyadmin3.3.9\
  • open/edit [config.inc.php]
  • find line [$cfg[‘Servers’][$i][‘password’] = ”;] and insert your password,  you should have something like [$cfg[‘Servers’][$i][‘password’] = ‘MyPassword’;]
  • save and refresh http://localhost/phpmyadmin/ ,  you can restart WAMP (Restart All Service) if you want but is not really necessary

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*