reset root password for Mysql on linux Box

If you missed your mysql root user password, then here are the steps to reset it:

1. stop mysql server
   service mysqld stop
2. make sure all mysql process are dead
   ps -A | grep mysql
3. start mysqld in safe mode
   mysqld_safe –skip-grant-tables
4. open a new shell window and start mysqld
   service mysqld start
5. access mysql database
   mysql -u root mysql
6. reset password of root user
   update user set Password=PASSWORD(‘yournewpassword’) where user=’root’;
7. stop mysqld_safe and restart mysql server
   service mysqld restart.

Happy Administration!