How to change the default empty mysql password in WAMP

After WAMP is installed, the mysql password is empty. How can I modify it? In fact, it is very simple. Just run a few commands. Next I will perform the operations step by step.

After WAMP is installed, the mysql tutorial password is blank. How can I modify it? In fact, it is very simple. Just run a few commands. Next I will perform the operations step by step.

First, open the mysql console through WAMP. Prompt to enter the password. Because it is empty, press Enter. Then enter" Use mysql", Which means to use the mysql Database tutorial and prompt" Database changed. Then enter the SQL statement" Update user set password = PASSWORD ('hooray') where user = 'root ';", Note that the semicolon at the end of the SQL statement should not be less, and the prompt is OK. Enter" Flush privileges;", If you do not enter this, the password change operation will not take effect. Then enter" Quit. In addition, many people say that using the php tutorial myadmin to directly modify the password in the mysql table should be correct in principle, but I found that the entire mysql database is missing after the modification, I re-installed the WAMP, and finally modified it through the command line. As you can find out, the operation is not difficult, because I found that mysql on my colleagues' computers are all empty passwords. In the future, if I had to configure a server, I would not be able to get a blank password.