MySQL forgot root password

1. Enter cmd into the command line window.

2, into the MySQL installation directory, such as my installation directory is C:\mysql, into the C:\mysql\bin;

3, skip permission check.

C:\mysql\bin>mysqld––skip-grant-tables.

4. Reopen a command-line window to enter C:\mysql\bin; (Close the running Mysqld.exe before this step).

5. Enter mysql-uroot-p appears in the new window input password:

Enter the carriage directly here without entering the password. The logon success message will then appear .

6. Use the command:

show databases;

7. Switch to MySQL database using the command:

Use MySQL;

8. Use the command to change the root password:

UPDATE user SET Password=password (' NewPassword ') where user= ' root ';

9. Refresh Permissions:

FLUSH privileges;

You can log in again .

MySQL forgot root password