MYSQL – Change default root password + WAMP server

Posted: March 14, 2011 in MySQL, WAMP Server
Tags: ,

1.Open PHPMyAdmin and goto sql editor and check root user password by using
SELECT user, host,PASSWORD FROM mysql.user;

2. Run the following sql command to change the password
 SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpwd’);

3. Changing the root password will create issue with PHPMyAdmin as it is by default configured to run with root and blank password. Reset it to new password in \wamp\apps\phpmyadmin3.3.9\ file

Refer for more details about all OS environments.


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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