wampserver The password is empty after installation,
There are generally three ways to modify:
first, through the phpMyAdmin directly modified;
the second is to modify the MySQL console using Wamp. Three is to reset the passwordThe
first type:
1. In the phpMyAdmin interface, click "User", the user profile of all users named "root"
The user's password is changed to "Password to be modified".
Modify is to click "Edit Permissions", set the password can be.
2. Under Directory Wamp\apps, locate the "config.inc.php" file under the phpMyAdmin folder,
Modify "$cfg [' Servers '] [$i] [' password '] = '", for "$cfg [' Servers '] [$i] [' password '] = ' password to be modified ';". Restart the
service. The
second type:
1. Open Wamp MySQL console, prompt for password, start password blank, press ENTER directly
enter "Use MySQL", console prompt "Database changed"
enter "Update user set Password=password (' Password to be modified ') where user= ' root ';",
Console Tip "Query ok,xxxxxxxxx"
finally enter "flush privileges", submit
enter "Quit" and exit.
2. Under Directory Wamp\apps, locate the "config.inc.php" file under the phpMyAdmin folder,
Modify "$cfg [' Servers '] [$i] [' password '] = '", for "$cfg [' Servers '] [$i] [' password '] = ' password to be modified ';".
Restart the service to
The Third Kind: After the change MySQL flash back unable to land the solution Reset
Password① to restart the
MySQL service by adding "Skip-grant-tables" to the "mysqlid" field in the file "My.ini "
② then go to the MySQL console and re-change the password in the second way.
③ Change the password after the "My.ini" added "Skip-grant-tables" deleted.
④ Restart Service
Wamp modified MYSQ Database L no landing solution