Solve the problem of forgetting password in MySQL 5.7 under Linux

1. Problem

Forgot password for mysql5.7 under linux

2. Solution

• Step 1: Open the mysql5.7 configuration file my.cnf and add a line to it: skip-grant-tables Save and exit (:wq)

[root@iz09a32x1sghz3z ~]# vi /etc/my.cnf

• Step 2: Restart mysql

[root@iz09a32x1sghz3z ~]# service mysqld restart

•Step 3: Log in to mysql and change the password

Log in with the root account: [root@iz09a32x1sghz3z ~]# mysql -u root

Use the mysql database in mysql: mysql> use mysql;

Change password: update user set authentication_string = password("Szfore_68638") where user="root" ;

Refresh the database: flush privileges;

Exit: quit;

Note: The password field in the user table of MySQL 5.7 has been changed to the authentication_string field.

At this time, the command you need to enter is update user set authentication_string = password("Szfore_68638") where user="root";

• Step 4: Open the mysql5.7 configuration file my.cnf, delete the line you just added: skip-grant-tables, save and exit (:wq)
•Step 5: Restart MySQL and log in with the modified password.

[root@iz09a32x1sghz3z ~]# service mysqld restart

Summarize

The above is what I introduced to you about how to solve the problem of forgetting the password of Mysql5.7 under Linux. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time!