What to do if you forget your linux mysql password

In the process of using the Linux operating system, the MySQL database is a widely used relational database management system. However, sometimes we may forget the password of the MySQL database, which will cause us to be unable to access the database. In this article, we will discuss some ways to solve this problem.

1. Reset MySQL database password

Resetting the MySQL database password is the most common solution. The following are the specific steps:

1. Stop the MySQL service. Enter the following command in the terminal:

sudo service mysql stop

2. Use the following command to start the MySQL service:

sudo mysqld_safe --skip-grant-tables &

3. To change the password in the MySQL terminal, enter the following command:

mysql -u root

This command will bring you into the MySQL terminal. Then enter the following command to change the password:

use mysql;

UPDATE user SET Password=PASSWORD('new password') WHERE user='root';

Note, here Replace "new password" with the new password you wish to set.

4. Use the following command to exit the MySQL terminal:

quit;

5. Stop the MySQL service. Enter the following command in the terminal:

sudo service mysql stop

6. Start the MySQL service using the following command:

sudo service mysql start

Now, You can now access the MySQL database using your new password.

2. Use the root user of MySQL to reset

If you are using the root user of MySQL, you can use the following steps to reset the password:

1. Enter MySQL terminal. Enter the following command in the terminal:

mysql -u root -p

This command will bring you into the MySQL terminal and prompt you for your password.

2. Change password. Enter the following command to change the password:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('New Password');

Remember, here you need to change the "New Password" Replace with the new password you wish to set.

Now, you can use the new password to access the MySQL database.

3. Use phpMyAdmin to make modifications

If you have installed phpMyAdmin, you can use the following steps to change your password:

1. Access phpMyAdmin. Enter the following URL into your web browser: http://localhost/phpmyadmin/

2. Enter your username and password. Enter your MySQL username and password on the login page.

3. Select the user. Select the "Users" tab on the left side of the phpMyAdmin interface.

4. Change password. Select the user whose password you want to change. Enter your new password in the "Change Password" tab.

5. Save changes. In the tab for changing your password, click Go.

Now you can access the MySQL database using your new password.

Summary

If you forget your MySQL database password, you can use Reset MySQL database password or use the MySQL root user to change the password. If you already have phpMyAdmin installed, you can also use this tool for password changes. No matter which method you use, you can restore access to your MySQL database.

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