← Back to team overview

maria-discuss team mailing list archive

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


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.


On 6/15/2014 10:36 AM, Peter Laursen <peter_laursen@xxxxxxxxxx> wrote:
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
<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

    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.



    Mailing list: https://launchpad.net/~maria-__discuss
    Post to     : maria-discuss@lists.launchpad.__net
    Unsubscribe : https://launchpad.net/~maria-__discuss
    More help   : https://help.launchpad.net/__ListHelp

Follow ups