查看连接mysql的ip命令

select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;

转载于:https://blog.51cto.com/haoyonghui/2131375