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 use MySQL, which means using MySQL as a database, prompting "database changed" on the line.
Then enter the SQL statement of the password that you want to modify update user set Password=password (' 123456 ') where user= ' root ', note that the semicolon at the end of the SQL statement must not be small, prompting what is OK.
Finally enter flush privileges, and if you do not enter this, the operation to change the password will not take effect.
Then enter quit to quit.
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.
Wamp How to set the password for a database