← 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:
http://blog.webyog.com/2011/12/19/how-to-add-a-simple-custom-object-in-monyog/

(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>
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.
>
> 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

References