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@webyog.com> wrote:
Maybe this wll help: http://blog.webyog.com/2011/12/19/how-to-add-a-simple-custom-object-in-monyo...
(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@libertytrek.org <mailto:tanstaafl@libertytrek.org>> 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@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-__discuss <https://launchpad.net/~maria-discuss> More help : https://help.launchpad.net/__ListHelp <https://help.launchpad.net/ListHelp>