Windows Mysql5.7 forgot root password solution

1. Open the first CMD window to execute net stop mysql57

2. Execute mysqld--defaults-file= "C:\ProgramData\MySQL\MySQL Server 5.7\my.ini"--skip-grant-tables in the first CMD window--- Note the path (whichever is your actual situation)

3, open the second cmd window to execute mysql-uroot-p prompt input password, direct return (do not enter the password)

4, select the database: Use mysql;

5. Update Root password: Update user set Authentication_string=password (' New password ') where user= ' root ' and host= ' localhost ';

6, Refresh permissions: Flush privileges;

7. Exit: Quit

8, re-login: MySQL -uroot -P prompt to enter a password, then enter the password to log in. Complete!!!

Windows Mysql5.7 forgot root password solution