MySQL sever Password

I used the following procedure and it worked very well.


Methods To Recover Lost MySQL Root Password On Linux And Windows
In some conditions we need recover MySQL root password. Following are the steps used on Windows and Linux for recovering the root password.
Recover MySQL root password on Linux
Under Linux we can accomplish the recovery using six steps. You need to be on root login to perform the following steps,
1. Stop MySQL server service.
# /etc/init.d/mysqld stop
2. Start MySQL server without password.
# mysqld_safe --skip-grant-tables &
3. Login into mysql client prompt.
# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.77 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>
4. Set up new MySQL root password.


mysql> use mysql;

mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

mysql> flush privileges;

mysql> quit

5. Stop Mysql Server
# /etc/init.d/mysqld stop
6. Start MySQL server and login as root.
# /etc/init.d/mysqld start
# mysql -u root -p
Recover MySQL root password on Windows Systems
Under Windows we can accomplish the recovery using eight steps. Following are the steps,
1. Stop MySQL server service.
Go to Start->Run->services.msc ,Stop MySQL server services.
2. Navigate into MySQL bin folder located inside the MySQL installation path.
Go to Start->Run->cmd
Use “cd” command to change the directory.
cd C:\MySQL\bin\
3. Execute the following command from “C:\MySQL\bin” command prompt.
mysqld.exe -u root --skip-grant-tables
4. Leave the current MS-DOS console as it and open a new MS-DOS console.
Go to Start->Run->cmd
Use “cd” command to change the directory.
cd C:\MySQL\bin\
5. Enter mysql.exe and Enter
mysql>
6. Set up new MySQL root password.


mysql> use mysql;

mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

mysql> flush privileges;

mysql> quit

7. Close all MS-DOS console and start MySQL server.
Go to Start->Run->services.msc ,Start MySQL server services.
8. Login into MySQL prompt.
Steps would be different according the MySQL installation.
Cheers!


I'm sorry that i did not record the link where I found this, so I give credit to somebody just don't know who.
MLver68