Forgot MySQL root password

1. cmd into console stop MySQL service

Command line: net stop MySQL

2. Switch to the MySQL installation under the bin directory, for example:

Command line: CD G:\MySQL\MySQL Server 5.6\bin

3, Execute Skip permission table limit parameters, after execution completes the command window does not close, re-cmd open another console window (May pop a warning, ignore)

Command line: mysqld--skip-grant-tables

4, in the new window to switch to the bin directory, the operation of the same step "2"

5. Execute command line: mysql-u root

6, enter after the execution command line: Update mysql.user set Password=password ("ABCD") where user= "root";

7. Refresh Permissions

Command line: Flush privileges;

8. Exit

Command line: \q

Complete, log in again.

Forgot MySQL root password