MySQL5.7 Forgot Password Solution

The first of these methods

First of all, it's generally seen online.

1. Close Service
2. windowsUnder in C:\ProgramData(隐藏文件夹)\MySQL\MySQL Server 5.7\my.ini the [mysqld]下 addskip-grant-tables
3. Restart the service, login again now no password required
4. Delete the original sentence skip-grant-tables , and then restart the service on the OK

But I follow this method in the third step of the time still need a password, if a classmate is like me, you can try the following method

The second method of

1. Close Service
2. windowsUnder in C:\ProgramData\MySQL\MySQL Server 5.7\my.ini the [mysqld]下 addskip-grant-tables
3. In a cmd window just enter mysqld --skip-grant-tables , and then open the second window direct input mysql can be directly into the
   

Change password, following several commands

1. use mysql
2. update user set authentication_string=password(‘密码‘) where user="用户" and host=‘localhost‘;
3. flush privileges;
4. Delete the original sentence, restart the skip-grant-tables service

MySQL5.7 Forgot Password Solution