← Back to team overview

maria-discuss team mailing list archive

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


It's the easiest and least locking way, I think. But if you want more detailed info:
SELECT * FROM information_schema.PROCESSLIST


El dom, 15/6/14, Tanstaafl <tanstaafl@xxxxxxxxxxxxxxx> escribió:

 Asunto: Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?
 CC: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Fecha: domingo, 15 de junio, 2014 16:38
 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.
 6/15/2014 10:36 AM, Peter Laursen <peter_laursen@xxxxxxxxxx>
 > 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>>
    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
 >     being used.
 >     Charles
 >     Mailing list: https://launchpad.net/~maria-__discuss
 >     <https://launchpad.net/~maria-discuss>
 >     Post to     :
 >     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
 >     Unsubscribe : https://launchpad.net/~maria-__discuss
 >     <https://launchpad.net/~maria-discuss>
 >     More help   :
 >     <https://help.launchpad.net/ListHelp>
 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