How to Reset and Recover MySQL or MariaDB Root Password on SystemD Linux

by Sandy

This article will come in handy. We will explain how to reset or recover forgottent MySQL or MariaDB root password in Linux. If you forgot root password for your MySQL database server running under Linux, there is still a way to reset mysql root password using this commands. In order to recover the password, you simply have to follow these steps:

1. Stop mysql:

systemctl stop mysqld

2. Set the mySQL environment option

systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

3. Start mysql usig the options you just set

systemctl start mysqld

4. Login as root

mysql -u root

5. Update the root user password with these mysql commands

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit

replace MyNewPassword with actual password

6. Stop mysql

systemctl stop mysqld

7. Unset the mySQL envitroment option so it starts normally next time

systemctl unset-environment MYSQLD_OPTS

8. Start mysql normally:

systemctl start mysqld

Now Try to login using your new password:

mysql -u root -p

If this post helps you in any way please consider a donation

Donate with PayPal :

md-donate

Donate with Paytm :

md-donate

You may also like

Leave a Reply

avatar
  Subscribe  
Notify of