如何查看连接MYSQL数据库的IP信息

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

mysql -u root -h127.0.0.1 -e "show processlist/G;"| egrep "Host/:" | awk -F: '{ print $2 }'| sort | uniq -c

mysql -u root -h127.0.0.1 --skip-column-names -e "show processlist;"|awk '{print $3}'|awk -F":" '{print $1}'|sort|uniq c