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 <[email protected]> escribió: Asunto: Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases? Para: CC: "Maria Discuss" <[email protected]> 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 <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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 : [email protected].__net > <mailto:[email protected]> > 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 : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
