mysql查询权限的用户名密码

用户名密码错误
进行下面操作查询用户密码
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
mysql> use mysql
mysql> select host,user,password from user;

果然如此。然后进行赋权

转载于:https://www.cnblogs.com/yuchunju/archive/2012/06/05/2536920.html