Apr 10, 2013

List Logged In MySQL Users using Perl DBI

I saw this question on Stackoverflow.com.  The user wanted to programatically list all users that are connected to MySQL database server.

He was using the SQL statement "show processlist;".  This is a very useful statement which lists all MySQL connections with additional information.