What to do if you forget mysql password in linux

When you need to log in to the MySQL database, entering an incorrect password will result in access being denied. At this point, some people may think of resetting their password, but what should you do when you forget your MySQL password?

In the Linux operating system, there are several ways to solve this problem, and we will introduce them one by one in this article.

Method 1: Use mysqladmin

mysqladmin is a tool in MySQL that can be used in the terminal to change the password.

1. First, enter the MySQL installation directory in the terminal. "your_mysql_path" in the command should be replaced with your MySQL installation directory.

cd your_mysql_path/bin

2. Stop the MySQL server. If you are using MariaDB, you should replace "mysqld" in the command with "mariadb".

sudo ./mysqld stop

3. Run the following command to change the password of the MySQL root user. Please note that you should replace "your_new_password" with the new password you want to set.

sudo ./mysqladmin -u root password your_new_password

4. Restart the MySQL server.

sudo ./mysqld start

Now you have successfully changed the password of the MySQL root user.

Method 2: Use MySQL Safe Mode

MySQL Safe Mode is a protected mode that enters the MySQL system level and allows you to enter MySQL as the root user and change the password.

1. Stop the MySQL server. If you are using MariaDB, you should replace "mysqld" in the command with "mariadb".

sudo systemctl stop mysqld

2. Turn on MySQL Safe Mode.

sudo mysqld_safe --skip-grant-tables &

3. Now that you have entered MySQL Safe mode, run the following command to change the password. Please note that you should replace "your_new_password" with the new password you want to set.

mysql -u root

mysql> use mysql;

mysql> update user set password=PASSWORD("your_new_password") where User='root';

mysql> flush privileges;

mysql> quit

4. Run the following command to restart the MySQL server.

sudo systemctl start mysqld

Now you have successfully changed the password of the MySQL root user.

Method 3: Delete MySQL database and reinstall

If the above two methods do not work, or you want to reset the MySQL database, then you can consider using this method.

1. Shut down the MySQL server. If you are using MariaDB, you should replace "mysqld" in the command with "mariadb".

sudo systemctl stop mysqld

2. Uninstall MySQL.

sudo apt-get remove --purge mysql*

sudo apt-get autoremove

sudo apt-get autoclean

3. Reinstall MySQL.

sudo apt-get install mysql-server

4. After completing the installation, start the MySQL server.

sudo systemctl start mysqld

Now, you can log in using the default MySQL root username and password.

Summary

The above are three methods to solve the problem of forgetting MySQL password under Linux operating system. While the forgotten password problem can be solved by using these methods, a better approach is to save the password so that it can be easily remembered when needed. Anyway, I hope this article was helpful to you.

The above is the detailed content of What to do if you forget mysql password in linux. For more information, please follow other related articles on the PHP Chinese website!