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

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>





Follow ups

References