Wamp modify MySQL default blank password in the

How to modify MySQL default blank password in Wamp

Wamp after the installation,MySQL tutorial 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. And then enter

Use MySQL

This means using MySQL as a database tutorial, prompting "database changed" on the line. Then enter the SQL statement for the password you want to modify

Update user set Password=password (' root ') where user= ' root ';

Note that the semicolon at the end of the SQL statement is not small, so it's OK to indicate what's okay. Last input

Flush privileges;

If you do not enter this, the operation to change the password will not take effect. And then enter

Quit