Sunday, May 4, 2008

Recovering MYSQL's root's password in Linux

Follow the below steps to recover MYSQL's roots password in Linux

Type the following commands at linux prompt

1. Type /etc/init.d/mysql stop
2. /usr/bin/killall mysqld
3. mysqld --skip-grant-tables -u root &
4. mysql
5. mysql> use mysql;
6. mysql> UPDATE user
7. -> SET password=password("putyourpasswordhere")
8. -> WHERE user="root";
9. mysql> flush privileges;
10. mysql> exit
11. /etc/init.d/mysql start

No comments: