You encountered an MySQL error that said: #1045 - Access denied for user 'root'@'localhost' (using password: YES) or#1045 - Access denied for user 'root'@'localhost' (using password: NO)error when you change your root @ localhost password from phpadmin and then try to access
http://localhost/phpmyadmin.This usually happen after you change ‘root’ password using phpmyadmin. It seems like phpmyadmin did not changing his password correctly.
Solution
Go to your mysql console from your wamp widget'
Enter your password, if it logs you out then uninstall your wamp (don't worry it will not delete your database) and before you reinstall go to your wamp folder and delete phpadminconfig file
**** Do not delete any folder there! or you will lose your database!****
*Reinstall the wamp and go back to the mysql monitor to insert this command
mysql> use mysql;
mysql>update user set password=PASSWORD("NEW-ROOT-PASSWORD") where user = 'root';
mysql>flush privileges;
mysql> quit
put your new password here "NEW-ROOT-PASSWORD"
login again if you are successful
go to locate your
phpmyadmin\config.inc.php to change your password there.After you’ve change your ‘root’ password using phpmyadmin, you should edit your
\wamp\apps\phpmyadmin\config.inc.php*stop all mysql services before proceed
*stop all mysql services before proceed
find this line of code:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password <-- type your new root password
Restart your mysql services and you’ll able to access your phpmyadmin back.
