[Maria-discuss] Easy way to see different users@hosts connected to all databases?
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
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> 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 Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
.. but not sure if this table is available in MariaDB 5.5 or not. On Sun, Jun 15, 2014 at 4:36 PM, 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> 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 Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
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>
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@libertytrek.org> escribió: Asunto: Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases? Para: CC: "Maria Discuss" <maria-discuss@lists.launchpad.net> 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@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>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Thanks for the replies, some useful info there, but I found a much simpler way (that gave me just what I needed): Log into mysql as root and do: show processlist; perfect! Thanks again, Charles On 6/15/2014 10:08 AM, Tanstaafl <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.
participants (3)
-
Federico Razzoli -
Peter Laursen -
Tanstaafl