Wampserver Modify and reset mysql password (go)

Transferred from: www.2cto.com/database/201504/387589.html

Wampserver the password is empty after installation,

There are two common ways to modify :

First, through the phpMyAdmin directly modified;

The second is to modify the MySQL console using Wamp.

The first type:

① 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.

② Locate the "config.inc.php" file under the phpMyAdmin folder under directory Wamp\apps,

Modify "$cfg [' Servers '] [$i] [' password '] = '", for "$cfg [' Servers '] [$i] [' password '] = ' password to be modified ';".

Restart the service.

The second type:

① Open Wamp MySQL console, prompt for password, start password blank, press ENTER directly

② input "Use MySQL", console prompt "Database changed"

③ input "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.

⑥ Locate the "config.inc.php" file under the phpMyAdmin folder under directory Wamp\apps,

Modify "$cfg [' Servers '] [$i] [' password '] = '", for "$cfg [' Servers '] [$i] [' password '] = ' password to be modified ';".

Restart the service to

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

Wampserver Modify and reset mysql password (go)