SHOW PROCESSLIST;
Caveat: you need to execute this command as a user with the PROCESS privilege in order to see all of the other users who are connected to the database. Otherwise, you see only those server threads that belong to the same user as the one making the query.
Thanks to : David Harper - Cambridge, England
Reference: http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html