用SHOW PROCESSLIST;命令查看当前的connectionmysql> SHOW PROCESSLIST; +----+------+----------------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+----------------+-------+---------+------+-------+------------------+ | 1 | root | localhost:2493 | mysql | Query | 0 | NULL | SHOW PROCESSLIST | +----+------+----------------+-------+---------+------+-------+------------------+ 1 row in set (0.06 sec)host列中你可以看到联接的用户主机。
+----+------+----------------+-------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------+-------+---------+------+-------+------------------+
| 1 | root | localhost:2493 | mysql | Query | 0 | NULL | SHOW PROCESSLIST |
+----+------+----------------+-------+---------+------+-------+------------------+
1 row in set (0.06 sec)host列中你可以看到联接的用户主机。