← Back to team overview

maria-discuss team mailing list archive

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


Maybe this wll help:

(you can of course use the query used as an example in the blog in whatever
client interface you want)

On Sun, Jun 15, 2014 at 4:08 PM, Tanstaafl <tanstaafl@xxxxxxxxxxxxxxx>

> 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.
> Thanks,
> Charles
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups