current connections to server

[Robert Citek]

Is there a way to get information about current connection to a MySQL
server?  Specifically, I would like to know how many users are currently
connected, who they are, from where, what databases are being used, etc.

I've browsed and searched the mysql manual and found the SHOW STATUS
command (http://www.mysql.com/doc/en/SHOW_STATUS.html).  This is a good
start, but does not have all the information I am looking for.

Any URLs or other pointers would be greatly appreciated.

Regards,
- Robert