Shulou(Shulou.com)05/31 Report--

Editor to share with you the solution to mysql forgetting your password. I hope you will get something after reading this article. Let's discuss it together.

MySQL is now very widely used, but sometimes suddenly forget the MySQL password, it is really very anxious, here is a way to reset the MySQL password, so that you are no longer worried.

1. First, we start the task manager, find the mysql.exe,mysqld.exe in the process, and close it.

2. Secondly, we can open the cmd window in the folder where MySQL is installed (using the shift+ right button)

Enter mysqld-skip-grant-tables, as shown in the following figure:

In this step, the main thing is to skip the authorization table.

3 account login

At this time, the login password is empty, so go straight back to the car line when you Enterpassword. The results are as follows

4 change the password

Enter the following command to change the password, the code is as follows:

Updatemysql.usersetpassword=password ('xxx') whereuser='root'

The details are as follows:

5 Refresh

The refresh here does not mean to refresh the computer desktop, but to enter the refresh command, otherwise the password will be the same the next time you log in, as follows:

Flushprivileges

6 restart

Shut down mysql,mysqld and restart.

After reading this article, I believe you have some understanding of "the solution to mysql forgetting password". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.