CentOS MySQL forgot password

1. Stop MySQL Services: service mysqld stop;

2.vim command to open MySQL configuration file my.cnf (General:/ETC/MY.CNF)

3. Add Skip-grant-tables in the mysqld process configuration file, and save after the add is complete.

4. Re-open the MySQL services: service mysqld stop;

5. Landing Mysql:mysql-u root-p; Login MySQL without entering a password;

6.update user Set Password=password (' NewPassword ') where user= ' root ' (5.7 previous version)

Update user set Authentication_string=password (' NewPassword ') where user= ' root ' (5.7 and later versions)

7. Comment Skip-grant-tables in the mysqld process configuration file, save after adding complete

8. Restart the MySQL service

CentOS MySQL forgot password