:: MySQL: reset root password

:: How to reset root password MySQL
+ stop mysqld

/etc/init.d/mysqld stop

+ starting mysql with skip grant table on background

mysqld_safe --skip-grant-tables &

+ login to mysql and reset password

mysql
use mysql;
update user set password=password('NEW_PASSWORD') where user='root';
quit;

+ kill mysqld

pkill -9 mysqld

+ starting mysql with new password

/etc/init.d/mysqld start

:: Links
+ Google
+ Kalpin