Resetting MySQL Root Password: CentOS

If you have forgotten the MySQL root password on CentOS you can reset by following the steps
Stop MySQL:
root# service mysqld stop

Start MySQL in safe mode:
root# mysqld_safe --skip-grant-tables &

Log into MySQL as root:
root# mysql -u root

Reset the password:
mysql> update mysql.user set password=PASSWORD("YourNewPassW0RD") where User='root';
mysql> flush privileges; exit;

Log out of MySQL and stop the Safe Mode:
root# service mysqld stop

Start MySQL in the normal mode:
root# service mysqld start

Log into MySQL with your new password:
root# mysql -u root -p
Enter password:
mysql> exit;