Wamp installed, the MySQL tutorial password is empty, then how to modify it? In fact, it is very simple, through a few instructions on the line, I have to operate the next step.
First, open the MySQL console via Wamp.
Prompt for password, because it is empty now, press ENTER directly.
Then enter "Use
mysql", meaning using the MySQL database tutorial, prompts "database changed" on the line.
Then 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, It's OK to hint what to do.
The last input "
flush privileges;", do not enter this, the operation of the password modification will not take effect.
Then enter "
quit" to exit.
In addition, many people said that through the PHP tutorial myadmin directly modify the MySQL table password on the line, the principle should be true, but I found that after the revision of the MySQL entire library is gone, the harm I reload the wamp, and finally through the command line to modify.
We can explore, in fact, the operation is not difficult, because I found that a colleague of the computer MySQL is a blank password, this later if with the server, but also to get a blank password is not finished.
