怎样查看连接数？就像sql server中的sp_who一样的功能

Question

mysql> show processlist;
*************************** 1. row ***************************
     Id: 4
   User: backup
   Host: 192.168.1.215:2787
     db: NULL
Command: Binlog Dump
   Time: 3182
  State: Has sent all binlog to slave; waiting for binlog to be updated
   Info: NULL
*************************** 2. row ***************************
     Id: 5
   User: ODBC
   Host: localhost:2098
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist
2 rows in set (0.00 sec)mysql>

Answer 1

./mysqladmin processlist例：
C:\Documents and Settings\zfl>mysqladmin processlist
+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host      | db | Command | Time | State | Info             |
+----+------+-----------+----+---------+------+-------+------------------+
| 2  | ODBC | localhost |    | Query   | 1    |       | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+