Reset MySQL root password

For Redhat,
Just a reminder for a working solution.

• service mysqld stop
• mysqld_safe --skip-grant-tables &
• mysql -u root mysql
• UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
• FLUSH PRIVILEGES;
• exit
• service mysqld start