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

This article will explain in detail how to reset the phpmyadmin password under wamp. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

(1) Open the mysql console of WAMP and prompt for a password. If the start password is empty, press enter directly.

(2) enter [use mysql] and prompt [Database changed] in the console.

(3) enter [update user set password=PASSWORD ('password to be changed') where user='root';]

There may be errors, password unknown, and so on.

Reason:

After the version was updated, password became authentication_string.

Solution:

Enter [update user set authentication_string=PASSWORD ('password to be changed') where user='root';]

At this point, the console prompts [Query OK,XXXXXXXXX].

(4) enter [flush privileges] and enter

(5) enter [quit] and exit

(6) find the [config.inc.php] file under the phpmyadmin folder in the directory wamp\ apps

Change [$cfg ['Servers'] [$I] [' password'] ='] to [$cfg ['Servers'] [$I] [' password'] = 'password to be changed';].

About how to reset the phpmyadmin password under wamp to share here, I hope the above content can be of some help to you, you can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.