How to modify the MySQL default null password in Wamp and how to fix the error of the Times

Wamp after the installation, MySQL password is empty, then how to modify it? Actually very simple, through a few instructions on the line, below I step by step to operate.

First, open the MySQL console via Wamp.

Prompt for password, because it is now empty, so press ENTER directly.

Then enter "Usemysql", meaning that using MySQL database, prompt "database changed" on the line.

Then enter the SQL statement for the password you want to modify "update user set Password=password (' Hooray ') where user= ' root ';", note that the semicolon at the end of the SQL statement must not be less, It's OK to suggest what's okay.

Finally enter "flush privileges;", do not enter this, the operation of the password change will not take effect.

Then enter "quit" to exit.

Once again download the installation, modify the MySQL password Error resolution method

The newly installed MySQL5.7, the login prompt password error, the installation did not change the password, and later through password-free way to change the password, enter the update mysql.user set Password=password (' root ') where user= ' Root ' Prompt error 1054 (42S22): Unknown column ' Password ' in ' Field List ', originally the MySQL database has no password This field, the password field changed to

Authentication_string

So change the statement to replace the update mysql.user set Authentication_string=password (' root ') where user= ' root ';

How to modify the MySQL default null password in Wamp and how to fix the error of the Times