Activities

December 2009
M T W T F S S
« Nov   Jan »
 123456
78910111213
14151617181920
21222324252627
28293031  

How to reset mysql root password

Here I have two environments. One I am working on Linux (mysql native) and other is WAMP on windows.

For linux,
This command would work simply.

#mysqladmin -u root password NEWPASSWORD -p

For Windows wamp mysql the above wont work because there is no mysqladmin shipped with WAMP mySQL installation. My Steps are listed below,
1, login with root account.
2, execute this command from the terminal
mysql> update user set password=PASSWORD(“rain”) where User=’root’;

That’s it

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>