Reset MySQL root Password

To reset MySQL root password, stop MySQL

service mysql stop

1	service mysql stop

Start MySQL with

mysqld_safe --skip-grant-tables

1	mysqld_safe --skip-grant-tables

Start another terminal, login to MySQL as root

mysql -u root

1	mysql -u root

Run following commands to change password.

update mysql.user set password=PASSWORD("PASSWORD_HERE") where User='root';
flush privileges;
quit

update mysql.user set password=PASSWORD("PASSWORD_HERE") where User='root';

flush privileges;

quit

Now you need to kill running MySQL processes and start MySQL as normal.

pkill mysql
service mysql start

1 2	pkill mysql service mysql start