MySQL查看所有连接的客户端ip

SELECT
	substring_index(HOST, ':', 1) AS host_name,
	state,
	count(*)
FROM
	information_schema. PROCESSLIST
GROUP BY
	state,
	host_name;