reset-mysql-root-password.md

[MySQL] Reset root password

Stop MySQL service

$ [sudo] service mysqld stop

Start MySQL in safe mode

$ [sudo] mysqld_safe --skip-grant-tables &

Connect to MySQL server without password

$ [sudo] mysql -u root

or

$ [sudo] mysql

Change the password

mysql> UPDATE mysql.user SET password = PASSWORD('newpassword') WHERE user = 'root';
mysql> quit;

Restart MySQL server

$ [sudo] service mysqld start

Check if the new password works

$ [sudo] mysql -u root -p'newpassword'