Solution to forgotten mysql password (picture)

mysqlWhat should I do if I forget my password? Uninstall and reinstall? This article mainly introduces in detail the method of resetting the password without uninstalling. It has certain reference value. Interested friends can refer to

Forgot mysql password twice? I did the stupidest thing at first, uninstalled and reinstalled.

Now there is a way to set the password back without uninstalling it. The knowledge comes from the Internet. I have sorted it out a little here. If you meet the same friends, you can try it.

The following implementations are all done on Windows systems.

Step 1

Find mysqld.exe in the task manager and end the process.

Second step

Find the bin directory under the mysql installation directory. Mine is C:\Program Files\MySQL\mysql-5.6.24 \bin

Open the console in this directory and enter: mysqld --skip-grant-tables

Step 3

Switch to the path just now and open a new controller

1) Enter: mysql

2) Enter: show databases;

3) Input: use mysql

4) Input: show tables;

You can now see the user table

Input: select user, password, host from user; you can see the contents of the table.

We now modify the data in the table through update.

Input: update user set password=passwrod("123456") where user="root" and host="localhost";

Since then, the password change of mysql has been completed.

The above is the detailed content of Solution to forgotten mysql password (picture). For more information, please follow other related articles on the PHP Chinese website!