Posted in

Reset MySQL root Password

To reset MySQL root password, stop MySQL

service mysql stop

Start MySQL with

mysqld_safe --skip-grant-tables

Start another terminal, login to MySQL as root

mysql -u root

Run following commands to change password.

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.

killall mysqld_safe
killall mysqld

Restart MySQL

service mysql start
Visited 1 times, 1 visit(s) today

Leave a Reply

Your email address will not be published. Required fields are marked *