← Back to team overview

maria-discuss team mailing list archive

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

 

.. but not sure if this table is available in MariaDB 5.5 or not.


On Sun, Jun 15, 2014 at 4:36 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
wrote:

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

References