Mysql 5.7 Liunx forgot password remedy

Linux under the root password of MySQL forgot to solve the party

1. To modify MySQL login settings
# VIM/ETC/MY.CNF
In the paragraph [mysqld], add one sentence:

Skip-grant-tables

For example:

[Mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/Mysql.sockskip 

2. Restart MySQL

Systemctl Restart Mysqld

3. You can now login MySQL without a password

Mysqld-uroot          //Direct Login

4. Update password

* Note that there is no password field in the user table in the new MySQL database , and it becomes authentication_string

mysql> Update Mysql.user Set Authentication_string=password (' XXXXXXXX ') where user= ' root ';

mysql> Flush privileges;mysql> quit;

5. Re-modify MySQL login settings

Add the first step to Skip-grant-tables's deletion

6. Restart Musql

Systemctl Restart Mysqld

Mysql 5.7 Liunx forgot password remedy