How to forget the MySQL root Password in Windows

How to forget the MySQL root Password in Windows

1. Open the MySQL configuration file my. ini and add skip-grant-tables to the end of the file or add it to the [mysqld.

2. Restart the MYSQL service.

In windows:
Net stop MySQL
Net start MySQL

If an invalid command is displayed, pay attention to the environment variable configuration.

3. Set the ROOT password

Output on the command

Select a database and use mysql.

Run the following statement to update the root password to 123456:
Update user set password = PASSWORD ("123456") where user = 'root ';

Quit exit MySQL

4. Restore the configuration file and restart

Delete the above "skip-grant-tables" and restart the service.

This article permanently updates the link address: