How to modify the MySQL default blank password in Wamp

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.

In addition, many people say that through the phpMyAdmin directly modify the MySQL table password on the line, the principle should be correct, but I found that after the change of MySQL entire library is gone, the harm I re-installed Wamp, eventually through the command line to modify.

We can find out, in fact, the operation is not difficult, because I found that colleagues on the computer MySQL is a blank password, this later if the server, also get a blank password is not finished.

One more step:
Open File
wamp/apps/phpmyadmin/config.inc.php
Modify this behavior, your password will be fine.
$cfg [' Servers '] [$i] [' password '] = ' your password ';

How to modify the MySQL default blank password in Wamp