MySQL常用show命令使用总结(9)

显示用户权限相关
mysql> SHOW GRANTS FOR test;
+-------------------------------------------+
| Grants for test@%                        |
+-------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' |
+-------------------------------------------+
1 row in set (0.00 sec)

显示运行进程
mysql> SHOW PROCESSLIST;
+----+------+-----------+-------+---------+------+----------+------------------+
| Id | User | Host      | db    | Command | Time | State    | Info            |
+----+------+-----------+-------+---------+------+----------+------------------+
|  6 | root | localhost | mysql | Query  |    0 | starting | SHOW PROCESSLIST |
+----+------+-----------+-------+---------+------+----------+------------------+
1 row in set (0.00 sec)

Linux公社的RSS地址：https://www.linuxidc.com/rssFeed.aspx