MySQL forgot root password modification method

Install the MySQL installation bin directory first (for example: C:xxx\xxx\mysql\bin add environment variable)

1. Enter net stop MYSQL5 or net stop MySQL under the Command line window

2. Open a command-line window and enter
Mysqld-nt--skip-grant-tables;

3. Open a DOS window again, mysql-u root

4. Enter:

The code is as follows:
Use MySQL
Update user set Password=password ("New_pass") where user= "root";
Flush privileges;
Exit

5, use the Task Manager, find the MYSQLD-NT process, end the process

Then enter in the Command line window: Mysql-u root-p Enter

Enter the password that you just set, and find that it's ready to go.

MySQL forgot root password modification method