mysql> show processlist; +-------+---------+---------------------+------+-----------+------+----------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+---------+---------------------+------+-----------+------+----------+------------------+ | 7 | monitor | 127.0.0.1:51060 | NULL | Sleep | 5 | | NULL | | 13105 | root | 192.168.200.1:49024| NULL | Query | 0 | starting | show processlist | +-------+---------+---------------------+------+-----------+------+----------+------------------+ 2 rows in set(0.00 sec) 提取 192.168.200.1 127.0.0.1