(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!