Wamp mysql Password modification

= = Method 1==

1. Open the MySQL console via Wamp and prompt for the password because it is now empty, so press ENTER directly.
2. Enter "Use MySQL", meaning that using MySQL this database tutorial, the hint "database changed" on the line.
3. Then enter the SQL statement for the password you want to modify "update user set Password=password (' Hooray ') where user= ' root ';"
4. Finally enter "flush privileges;"

= = Method 2==

Open Wamp phpMyAdmin, enter its management interface, click on permissions, then the page will display a User rights table, find the user is: root, Host: localhost data row, click the Edit button, pop up the detailed permission configuration page, find the Change password entry inside, Two times after entering the password you want to change, click Execute to complete the password modification of [email protected] permission in the database.

Locate the phpMyAdmin installation directory under the Wamp directory, locate the config.inc.php file in the phpMyAdmin installation root directory, and open it to find that the value of $cfg[' Servers ' [$i] [' Password '] is empty, Modify the password set for the first step of the value. Restart the Wamp service.

Wamp mysql Password modification