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\config.inc.php file

Refer http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html for more details about all OS environments.

Advertisements

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 )

Google+ photo

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

Connecting to %s