Integrated WAMP Environment command not works, change password in phpMyAdminPermissions--root user modification, executionthen you'll find that you can't log in with phpMyAdmin.
Modify the phpMyAdmin inside the corresponding password can be phpmyadmin in the config.inc.php in the
$cfg [' Servers '] [$i] [' password '] = ', the value changed to the modified password;
cmd under switch to MySQL installation directory
Cases
D:/mysql/bin
Prerequisite: The MySQL user root password is empty.
Input mysql-u root MySQL
mysql> state Input Update user set Password=password (' New password ') where user= ' root ';
Echo Echo
Query OK, 0 rows Affected (0.00 sec)
Rows matched:2 changed:0 warnings:0
mysql> State input FLUSH privileges;
Echo Echo
Query OK, 0 rows Affected (0.00 sec)
mysql> status Input quit
Exit SQL
Note that each command is preceded by a semicolon ";"
MySQL only starts executing the line command
The second command updates the MySQL system repository that is loaded into the memory.
Re-start MySQL.
Then you'll find that you can't log in with phpMyAdmin.
Modify the phpMyAdmin inside the corresponding password can be phpmyadmin in the config.inc.php in the
$cfg [' Servers '] [$i] [' password '] = ', the value changed to the modified password; Source Address: http://blog.sina.com.cn/s/blog_6e44ac5101012tvl.html
MySQL change root password in WAMP environment