:: 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
