What if I forget my mysqlroot password?

1. Cmd Open command line, enter net stop MySQL, stop MySQL service

2. Go to the MySQL installation directory (e.g. you put it in E:\mysql-5.6.14-winx64\bin)

Input command: (1) E:

(2) CD Mysql-5.6.14-winx64\bin

3. Go to MySQL Safe mode, that is, when MySQL gets up, you can enter the database without entering a password.
The command is: Mysqld-nt--skip-grant-tables

4. Re-open a command line, enter mysql-uroot-p, use a blank password to log in to MySQL (Do not enter the password, directly press ENTER)

5. Modify the root user's password
mysql> Update Mysql.user Set Password=password ("New password") where user= "root";

6. Refresh the Permissions table
mysql> flush Privileges;

7. Exit
Mysql> quit

8. Close the open command line to restart MySQL, the new password will take effect.

What if I forgot my mysqlroot password?