Home  >  Article  >  Database  >  How to reset phpmyadmin password under wamp

How to reset phpmyadmin password under wamp

王林
王林Original
2019-12-13 11:38:122561browse

How to reset phpmyadmin password under wamp

(1) Open the mysql console of WAMP and prompt for a password. The password will be blank at first, just press Enter

(2) Enter [use mysql], The console prompts [Database changed]

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

may prompt Error, password unknown, etc.

Cause:

After the version is updated, password becomes authentication_string.

Solution:

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

The console prompts at this time [Query OK,XXXXXXXXX].

(4) Finally enter [flush privileges], press Enter

(5) Enter [quit], exit

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

Modify [$cfg['Servers'][$i]['password'] = ''] to [$cfg['Servers'][ $i]['password'] = 'Password to be modified';] That's it.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to reset phpmyadmin password under wamp. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn