title: List logged-in MySQL users
body: <p>I'd like to have a script that shows the users who are logged in to my server through MySQL.  Right now I use</p>
  
  <pre><code>show processlist;
  </code></pre>
  
  <p>and manually open each of the BLOBs to see which entries correspond to the server itself, which correspond to robots, which correspond to inactive users, and so forth.  But there has to be a better way!</p>
  
  <p>I was imagining a Perl script, but perhaps there's a better way.  Surely it is not rare to wonder who is logged in -- is there some standard tool?</p>