How to change mysql password after forgetting it

Mysql method to change the password after forgetting it: 1. First enter the MySQL database and use the command to connect to the database; 2. Stop the MySQL service before entering the password; 3. Use the command to enter the MySQL safe mode; 4. Use the command to connect to MySQL; 5. After the connection is successful, use the command to modify the MySQL password; 6. After the modification is completed, use the command to exit MySQL; 7. Use the command to restart the MySQL service.

#MySQL is a popular open source relational database management system. During use, it is easy to forget the MySQL password. At this time, the MySQL password needs to be modified to avoid affecting the normal use of the database.

In MySQL In version 8.0, the password modification method is different from the previous version. You need to use the "caching_sha2_password" encryption method. Let's introduce how to modify the forgotten MySQL. 8.0 Password.

1. First enter the MySQL database and use the following command to connect to the database:

mysql -u root -p

2.: Stop the MySQL service before entering the password. You can use the following command to stop the MySQL service. :

sudo service mysql stop

3. :Next, use the following command to enter MySQL safe mode:

sudo mysqld_safe --skip-grant-tables &

Note: The "&" symbol represents running in the background in Linux systems.

4. Use the following command to connect to MySQL:

mysql -u root

5. After the connection is successful, use the following command to change the MySQL password:

FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 
'new_password';

The "new_password" here is the new password you want to set and needs to be replaced with the password you want to set.

6. After the modification is completed, use the following command to exit MySQL:

exit;

Step 7: Use the following command to restart the MySQL service:

sudo service mysql start

Modify MySQL After completing the password, you need to remember the new password and keep it properly to avoid forgetting the password again.

The above is the detailed content of How to change mysql password after forgetting it. For more information, please follow other related articles on the PHP Chinese website!