I encounter a problem with my localhhost and I have tried a lot of solutions, none of them working. I changed the password of my root user and then this error appears
“MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: YES) 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 uninstalled xampp and I installed it again
Change the config.inc.php file in the line
$cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = '';
and insert your password
3.Cookies deleted (from the control panel – Internet Options
4.Turn of MySql from control panel – administrative tools – services – mysql
change line 4 to: mysql_connect("localhost","root","enter password here");
change line 64 to: if(!mysql_connect("localhost","root","enter password here"))
6. - Go to file C:\wamp\apps\phpmyadmin220.127.116.11\config.inc.php (I guess you would replace "wamp" with the name of your server if you're not using Wamp Server)
Find the line $cfg['Servers'][$i]['password']='' and change this to $cfg['Servers'][$i]['password']='NO'
Try opening phpMyAdmin again, and hopefully the message will now read "Access denied for user 'root'@'localhost' (using password: YES)
Now change the password in the above line to 'yourpassword' (whatever you had set it to before)
and at last I followed the instructions http://support.microsoft.com/kb/972034
but still I have the same problem. Is there anybody could help me?