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!