=====================================
查看当前连接到数据库的用户和Host
## 查看当前连接到数据库的用户和Host ##
SELECT DISTINCT
USER,HOST
FROM `information_schema`.`PROCESSLIST` P
WHERE P.USER NOT IN('root','repl','system user') \G
=====================================
查看当前连接到数据库的用户和Host
## 查看当前连接到数据库的用户和Host ##
SELECT DISTINCT
USER,HOST
FROM `information_schema`.`PROCESSLIST` P
WHERE P.USER NOT IN('root','repl','system user') \G