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
