The problem:
I’ve received an email from a friend that encountered an MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
error when he is trying to access his http://localhost/phpmyadmin.
This happened after he tried to change ‘root’ password using phpmyadmin. It seems like phpmyadmin not changing his password correctly.
The cure:
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
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 😀
thank you so much. it worked
thanks, works like a dream. I installed Joomla! which rqd a pssd, and this advice helped me get phpmyadmin back on track. thanks!
Thank you – You are a life saver. Its great people like you that make the internet an awesome resource.
THANK YOU SO MUCH!! This just saved my life 😀
Thanks a lot for your help. Now it works correctly
I had a same problem after changing root user password using phpmyadmin, but now it is solved.
Thank you for this great trick.
glad to hear it worked for you. cheers =)
phpMyAdmin – Error
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly
I got this error while change root password and edit config.inc. How can it solve?
Plz Help me…….
ok I had the same prob. I did what you said and still got the error is there a way I can change my password that I set I’m thinking I might have hit a wrong button or something when I put it in 😦
it resolve my very big problem thnxxxxxx
very usefull. tnx…
I remember when I first installed Wamp. Changing the password threw me for such a loop because I wasn’t used to config files. Great article, thank you! If you are interested I have a simple walk through explaining how to change root password for Wamp on a Windows based machine here: http://www.itutorblog.com/2011/06/how-to-change-root-password-on-wamp/
Thank you for this post, it provided just the information I needed; without all the bull surrounding it.
I thought I was going to have to reinstall wamp for a minute then!
Thanks again,
Matt
For the people that still have this problem after changing the password in the config.inc.php…
You need to delete your browser cache as well, then try again!
thats right. thanks jerkey 🙂
realtalk you’re the man bro
8 liner cure …..
akupunyalah bersungguh baca forum, panjang lebar depa explain. Masuk command line bagai….
Thanks bro
thnkueeeeeeee so much…..its help me to get out a problm which i ws facing from last 2 dayz…
Thanks a lot……!
Its working fine
This was huge help. Not to take anything away from what you wrote, but ff you could update your article to include clearing the browser cache that would be nice, as clearing the cache was the missing step that solved the problem for me.
I have wamp server new version with windows 7, I don’t know what’s the problem with my wamp server..still it dowsn’t work…
🙂
then your user should be : root
password should be empty;
It actually works. Thanks man!