2016/7/7 set wamp2.5 mysql password focus is MySQL version

Be aware of the MySQL version when setting your password. Different versions, different effects. Method/Step

1. After installing Wamp, right click on wamp->mysql->mysql Console (console).

2. Prompt for password, because the password is empty, so press ENTER directly. Then enter "Use MySQL", meaning that using MySQL database, prompt "database changed" on the line.

3. Then enter the SQL statement for the password you want to modify "update user set Password=password (' Your password ') where user= ' root ';", note that the semicolon at the end of the SQL statement must not be small, prompting what is OK on the line.

4. Finally enter "flush privileges;", do not enter this, the operation of the password change will not take effect

5. Then enter "Quit" to exit.

6. Finally, you want to modify the configuration of the next phpMyAdmin. Locate the D:\wamp\apps\phpmyadmin4.1.14 file and open the Find $cfg[' Servers ' [$i] [' password '] = ' If my password is 123456 '; Enter the modified password in the quotation marks, and then it's OK.

7. 7

   Finally restart the Wamp Plus, change the password successfully, again into the MySQL console is to enter your password

2016/7/7 set wamp2.5 mysql password focus is MySQL version