Modify the default null password for MySQL in Wamp

Wamp after the installation, MySQL password is empty, then how to modify it?

First, open the MySQL console.

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

B. Enter "Use MySQL", which means using MySQL database

III. Enter the SQL statement for the password to be modified "update user set Password=password (' Hooray ') where user= ' root ';" Note that the semicolon at the end of the SQL statement cannot be less.

Enter "flush privileges;", if you do not enter this, the operation to change the password will not take effect.

Then enter "quit" to exit.

Modify the default null password for MySQL in Wamp