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

代码语言：javascript复制

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

host ip mysql 客户端 连接

0 人点赞