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 the original password, if it is empty, 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 (' Enter the password you need to set ') 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.