MySQL operations under wampserver

Modify the MySQL password:

Prompt to enter the original password. If it is null, press Enter.

Then enter"Use MySQL", Which means to use the MySQL database and prompt" database changed.

 

Then enter the SQL statement"Update user SET Password = PASSWORD ('Enter the password you want to set ') where user = 'root ';", Note that the semicolon at the end of the SQL statement should not be less, and the prompt is OK.

 

Enter"Flush privileges;", If you do not enter this, the password change operation will not take effect.

 

Then enter"Quit.

 

After changing the MySQL password, phpMyAdmin cannot be entered. You need to change the new password.

You can also change the password in phpMyAdmin: