1.通过mysql数据库的user表查看用户相关信息
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *87F2746835A04895BB77E12AA5054A767******* |
| qxyw | root | |
| 127.0.0.1 | root | |
| localhost | | |
| qxyw | | |
+-----------+------+-------------------------------------------+
5 rows in set (0.00 sec)<