Shulou(Shulou.com)06/01 Report--

Editor to share with you the solution of phpmyadmin forgetting password, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The solution to phpmyadmin forgetting your password:

Step 1: locate the my.ini file in the installation MYSQL directory. For example, my location is: d:\ wamp64\ bin\ mysql\ mysql5.7.14

Find the location in the figure and add a statement to save: skip_grant_tables

Or

A very useful mysql startup parameter-skip-grant-tables.

As the name implies, the authorization table is not started when mysql is started. What's the use? Of course, it is useful after forgetting the administrator's password.

Then restart the service and start wampserver

Step 2: open cmd, enter the bin directory of mysql, and enter mysql-uroot-p to enter as shown below:

There is no need to enter the password, and then enter, as shown in the figure:

The cmd appears as shown in the above figure, which means that you have successfully entered.

Step 3: reset the password

Enter update mysql.user set password=password ('root') where user='root'; to enter and restart wamp to change the password successfully.

Tips:

1. If the error occurs in step 3: prompt ERROR 1054 (42S22): Unknown column 'password' in' field list', it is because the MYSQL version is too high.

Modify the statement in step 3 to: update mysql.user set authentication_string=password ('root') where user='root';

2. After the modification is successful, remember to delete the skip_grant_tables added in the first step, otherwise errors may occur later.

These are all the contents of this article entitled "the solution to phpmyadmin forgetting your password". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.