maria-discuss team mailing list archive

[Tanstaafl <tanstaafl@xxxxxxxxxxxxxxx>]

Actually, I found a much easeir way (for what I needed to see):

log into mysql as root, and do:

show processlist;

Exactly what I needed.

But thanks for the other responses, may come in handy later.

Charles

On 6/15/2014 10:36 AM, 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
> <mailto: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
>     <https://launchpad.net/~maria-discuss>
>     Post to     : maria-discuss@lists.launchpad.__net
>     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~maria-__discuss
>     <https://launchpad.net/~maria-discuss>
>     More help   : https://help.launchpad.net/__ListHelp
>     <https://help.launchpad.net/ListHelp>