Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?

15 Jun 2014

      Thanks for the replies, some useful info there, but I found a much 
simpler way (that gave me just what I needed):

Log into mysql as root and do:

show processlist;

perfect!

Thanks again,

Charles

On 6/15/2014 10:08 AM, Tanstaafl <tanstaafl@libertytrek.org> wrote:
...
Is there a simple command I can issue to see a list of the current
users@hosts connected to all of the databases of a running mariadb server?
I'm trying to troubleshoot a problem where an update from 5.5.30 to
5.5.37 recently caused all of the connections from my groupware host to
start coming from a different hostname, and so were being denied. I need
to be able to see if changes that I make change the hostname being used.