wamp:change phpmyadmin root password

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 😀

24 thoughts on “wamp:change phpmyadmin root password

  1. thanks, works like a dream. I installed Joomla! which rqd a pssd, and this advice helped me get phpmyadmin back on track. thanks!

  2. 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…….

  3. 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 😦

  4. 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

  5. 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!

  6. 8 liner cure …..
    akupunyalah bersungguh baca forum, panjang lebar depa explain. Masuk command line bagai….

    Thanks bro

  7. 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.

  8. 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…

Leave a reply to Sapan Cancel reply