MySQL is a very popular database management system that is widely used in the development of web applications. Since it is necessary to set important information such as login password and root password during the installation and use of MySQL, it is often the case that the MySQL root password is forgotten. This article will introduce how to deal with this situation from various aspects.

1. Retrieve MySQL root password

1. Use the mysqladmin command

In a Linux or Mac terminal, you can use the mysqladmin command to retrieve the MySQL root password. The specific steps are as follows:

Step 1: Open the terminal

Step 2: Use the following command to log in to the MySQL database:

mysql -u root -p

Step 3: Enter your password. If you forget it, skip to step 4

Step 4: Use the following command to reset the root password:

mysqladmin -u root password NEWPASSWORD

2. Modify the MySQL configuration file

If you forget the MySQL root password, you can also retrieve it by modifying the configuration file. The following are the specific steps:

Step 1: Find the MySQL configuration file

In Linux systems, the MySQL configuration file is usually /etc/my.cnf or /etc/mysql/my.cnf . On Windows systems, the configuration file is usually located in C:Program FilesMySQLMySQL Server X.Xmy.ini.

Step 2: Stop the MySQL service

In the Linux or Mac terminal, use the following command to stop the MySQL service:

sudo /etc/init.d/mysql stop

In Windows system, open the service list, find the MySQL service, right-click and select "Stop".

Step 3: Edit the MySQL configuration file

Use a text editor to open the MySQL configuration file. Find the following line:

[mysqldump]
user=root
password=OLD_PASSWORD

Change the original password to the new password you want. For example, if you want to change the password to "apple", you would write:

[mysqldump]
user=root
password=apple

Step 4: Start MySQL Service

In the Linux or Mac terminal, use the following command to start the MySQL service:

sudo /etc/init.d/mysql start

In the Windows system, open the service List, find the MySQL service, right-click and select "Start".

2. Prevent the MySQL root password from being forgotten

1. Record the password

When you set and change the MySQL root password for the first time, it is recommended to use a password management tool to record the password so that Prevent forgetting. You can choose a password management tool like 1Password or LastPass to record passwords.

2. Enable MySQL password policy

MySQL supports the use of password policies to force users to use complex passwords, thereby increasing the difficulty of password cracking. You can enable password policy by editing the MySQL configuration file. The following are the specific steps:

Step 1: Find the MySQL configuration file

In Linux systems, the MySQL configuration file is usually /etc/my.cnf or /etc/mysql/my.cnf . On Windows systems, the configuration file is usually located in C:Program FilesMySQLMySQL Server X.Xmy.ini.

Step 2: Edit the MySQL configuration file

Use a text editor to open the MySQL configuration file. Find the following line:

[mysqld]

The default authentication plugin to be used when connecting to the server

default_authentication_plugin=mysql_native_password

Will be the default authentication plugin Modify plugin to mysql_native_password and add the following content:

[mysqld]

The default authentication plugin to be used when connecting to the server

default_authentication_plugin=mysql_native_password

Set password rules

validate_password_policy=STRONG

Password length min, max

validate_password_length=8
validate_password_mixed_case_count=1

Password validity period

default_password_lifetime=365

The above setting will enable the following password policy:

• Password must be at least 8 characters long;
• Contains an uppercase letter;
• contains lowercase letters;
• contains numbers;
• contains special symbols;
• The password must have a mixed case character;
• The password is valid for one year.

Finally, restart the MySQL service.

Step 3: Restart the MySQL service

In the Linux or Mac terminal, use the following command to restart the MySQL service:

sudo /etc/init.d/mysql restart

In Windows system, open the service list, find the MySQL service, right-click and select "Restart".

Summary:

Forgetting the MySQL root password often causes a lot of inconvenience. This article introduces how to retrieve the MySQL root password according to different situations. At the same time, this article also recommends some preventive measures, such as logging passwords and enabling MySQL password policies. In the future use of MySQL, I hope these measures can help you better manage passwords and avoid the trouble caused by password issues.

The above is the detailed content of mysql root password forgotten. For more information, please follow other related articles on the PHP Chinese website!