Tuesday, January 15, 2013

WAMP MySQL Error 1045

I have just started dabbling with wordpress. So as a first step I decided to set it up in my local system with WAMP server. Pretty surely, as soon as I set it up I ran into the mysql issue when I tried to open the phpmyadmin console in the web browser.


 #1045 - Access denied for user 'root'@'localhost' (using password: NO)
OR

 #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I figure this is a common error when setting up, but it surely wasted a lot of my time.
Here are the common steps that one can go through to fix this,

  1. Open MySQL console and login to MySQL. If you are able to login, then ensure that the password that you used to login is updated into "wamp/apps/phpmyadmin/config.inc.php".
  2. Restart WAMP server
  3. Delete all files in "wamp/tmp"
  4. Delete all cookies from your browser
After these steps try opening the phpmyadmin console again. Hopefully you won't have the same error again.

No comments :