使用phpMyadmin误删root@localhost 用户 的解决办法

初次使用phpmyadmin，新建一了一个rootroot的用户后，一时手残直接删除了三个root账户，删后才找到他们的意义，附上如图

解决办法： 使用普通用户登录，不会被拒绝。 普通用户 rootroot D:\wamp\bin\mysql\mysql5.6.17\bin>mysql -u rootroot -p Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.6.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql; Database changed mysql> select user from user; +----------+ | user | +----------+ | root | | rootroot | +----------+ 2 rows in set (0.00 sec) 查看用户， mysql> select user,host from user; +----------+-----------+ | user | host | +----------+-----------+ | root | localhost | | rootroot | localhost | +----------+-----------+ 2 rows in set (0.00 sec) 发现rootroot是localhost。。。。 但是phpmyadmin主页一直是拒绝的，

打开phpMyadmin中的config.inc.php ，修改user和password $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; 改为$cfg['Servers'][$i]['user'] = 'rootroot'; $cfg['Servers'][$i]['password'] = 'root';

成功登录以后，对root@localhost进行授权，之后使用root后就能重新登录了

转载于:https://my.oschina.net/yamsh/blog/1635555