HowTo: Reset Mysql root password

We can reset the Mysql database server password with following 5 easy steps.


1) Stop the MySQL server demon process.
#/etc/init.d/mysql stop
2) Start the MySQL (mysql) server/daemon process with the --skip-grant-tables option so that it will not prompt for password
#mysqld_safe - -skip-grant-tables &
3) Connect to mysql server as the root user
#mysql -u root
4) Setup new root password
mysql> use mysql;
mysql> update user set password=PASSWORD("anypassword") where User='root';
mysql> flush privileges;
mysql> quit
5) Exit and restart MySQL server
/etc/init.d/mysql stop
/etc/init.d/mysql start