maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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

Regards
Federico


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

 Asunto: Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?
 Para: 
 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.
 
 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>
 >
 >
 
 
 _______________________________________________
 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