Recover a MySQL root password

If we forgot the mysql root password, don't worry. We can update the mysql root passord by following the below mentioned steps ..

Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

# /etc/init.d/mysql stop
# mysqld_safe –skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(“newrootpassword”) where User=’root’;
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Now we can give the  newrootpassword as root passwd for mysql. That is ,

#mysql -u  root -p
#newrootpasswor
 mysql>