MySQL Reset Root Password

Stop MySQL server

sudo systemctl stop mysql

// OR

/etc/init.d/mysql stop

Start MySQL server without loading grant table

The ampersand & at the end of the command above will cause the program to run in the background, so you can continue to use the shell.

When the --skip-grant-tables option is used, anyone can to connect to the database server without a password and with all privileges granted.

sudo mysqld_safe --skip-grant-tables &

Once safe mode has started up, log into MySQL and when prompted, use your standard root password.

mysql -u root mysql

Update user root password.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MY_NEW_PASSWORD';

If the above command does not work, try this.

UPDATE mysql.user SET authentication_string = PASSWORD('MY_NEW_PASSWORD') WHERE User = 'root' AND Host = 'localhost';

Be sure to reload everything.

FLUSH PRIVILEGES;

Now you have a new password “MY_NEW_PASSWORD”

Stop and restart the server normally

Stop server

mysqladmin -u root -p shutdown

Start server

sudo systemctl start mysql

//OR

/etc/init.d/mysql start

Verify your password change

mysql -u root -p

Enter your password. If you get in then you password has been successfully reset.

 




Subscribe To Our Newsletter
You will receive our latest post and tutorial.
Thank you for subscribing!

required
required


Leave a Reply

Your email address will not be published.