Mysql5.7 How do I change my password if I forgot my password?

1. Stop the Service

2.mysqld--skip-grant-tables

3. After the carriage return, do not move, and then open a new command Prompt window, also into the MySQL installation directory,

Input: Mysql-u root-p

Password is empty, direct return

Then enter the following command:

Use MySQL;

Update user set Authentication_string=password ("123456") where user= "root";

Flush privileges;

Once the above three commands have been executed, open a command Prompt window,

Input Mysql-u root-p, enter (if the environment variable is configured, not configured can self-Baidu)

Enter Password: 123456

4. Before restarting the service, you need to kill the MySQL task in Task Manager

Mysql5.7 How do I change my password if I forgot my password?