What to do if you forget your mysql password

Forgot your MySQL password twice? At first I did the stupidest thing, uninstalling and reinstalling.

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

The following implementations are all completed on Windows systems.

first step

Find mysqld.exe in the Task Manager and end the process.

Step 2

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

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

Step 3

Switch to the path just now and open a new controller

1) Input: mysql

2) Input: show databases;

3) Input: use mysql

4) Input: show tables;

At this time you can see the user table

Input: select user,password,host from user; you can see the contents in 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 mysql password has been changed.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.