Thursday, January 29, 2015

#1045 - access denied for user 'root'@'localhost' (using password no) xampp

I had this problem after changing the password for the root user in phpMyAdmin. I know nothing about programming but I solved it by doing the following:
  1. Go to file C:\xampp\phpMyAdmin\config.inc.php
    (I guess you would replace "wamp" with the name of your server if you're not using Wamp Server)
  2. Find the line $cfg['Servers'][$i]['password']='' and change this to
    $cfg['Servers'][$i]['password']='NO'
  3. Try opening phpMyAdmin again, and hopefully the message will now read "Access denied for user 'root'@'localhost' (using password: YES)
  4. Now change the password in the above line to 'yourpassword' (whatever you had set it to before)
Hope this helps somebody.


For screen shot &  command prompt you can visit following link.

https://www.ostraining.com/blog/coding/error-1045-phpmyadmin/

No comments:

Post a Comment