MySQL查看连接的客户端ip

SELECT substring_index(host, ':',1) AS host_name,state,count(*)
ROM information_schema.processlist GROUP BY state,host_name;