← Back to team overview

maria-discuss team mailing list archive

Re: Easy way to see different users@hosts connected to all databases?


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;


Thanks again,


On 6/15/2014 10:08 AM, Tanstaafl <tanstaafl@xxxxxxxxxxxxxxx> 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.