How to deal with MySQL password forgotten

Solution to MySQL password forgetting: 1. Stop the mysql service. Open the command line window and stop mysql service: netstopmysql2. Start mysqlgenerally to install mysql. Find mysqld-nt.exe and execute: mysqld-nt -- skip-grant-tables. The current window will stop. 3. Open a command line window and enter

Solution to MySQL password forgetting: 1. Stop the mysql service. // Open the command line window and stop mysql service: Net stop mysql 2. Start mysql, usually to the installation path of mysql, find the mysqld-nt.exe to execute: mysqld-nt -- skip-grant-tables the current window will stop. 3. Open a command line window and enter

Solution to MySQL password forgetting:

1. Stop the mysql service. // Open the command line window and stop the mysql service: Net stop mysql

2. Start mysql, usually to the installation path of mysql, find the mysqld-nt.exe

Run: mysqld-nt -- skip-grant-tables. The current window will stop.

3. In addition, open a command line window, enter the BIN directory of the MYSQL installation location, and run mysql

4. Run the following command:

> Use mysql

> Update user set password = password ("new_password") where user = "root ";

> Flush privileges;

> Exit

6. Use Ctrl + Alt + Del to find the mysqld-nt process and kill it. After restarting the mysql-nt service, you can log on with the new password.