WAMP 2.2 – Setting root pwd on MySQL nice and easy

Wamp 2.2 starts as default without MySQL password on user root. That’s a bad idea, and MyPhpAdmin 3.4.5 correctly complains about the situation. Most answers found on the Net assume you are a MySQL laureate. This post is mainly a reminder for myself but if anyone finds it useful, I’ll be glad.

Sequence in MyPHPAdmin 3.4.5:
– select db mysql in left column
– select table user in left column at the bottom
– select EDIT for row user root@localhost
– go to row “Password” (should be the third one)
– pick PASSWORD from dropdown list of functions in field FUNCTION
– type your pwd in clear inside field VALUE
– click GO

What to do afterwards:
– open c:\wamp\apps\phpmyadmin3.4.5\config.inc.php
– type your pwd in clear in the line $cfg[‘Servers’][$i][‘password’] = ”;
– restart all wamp services

You can have a look at the enclosed images.

This slideshow requires JavaScript.

If this does not address your case, either your Wamp version or this post are obsolete 🙂


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s