SEO

permalink · #1 (**permalink**) 02-28-2008, 07:12 AM

hi!
how to see users logged into mysql?
I would like to know who is actually logge into MySQL under my slack

greetings
jerzu

permalink · #2 (**permalink**) 02-28-2008, 07:12 AM

Hi,

If you have the SUPER privilege, you can do this with 'show processlist'
(without the SUPER privilege, you will only see your connections).

Markus

"nousernospam" <nousernospam@wp.pl> schrieb im Newsbeitrag
news:gxle5x1tqsfx.10h8gaj5kycib.dlg@40tude.net...
> hi!
> how to see users logged into mysql?
> I would like to know who is actually logge into MySQL under my slack
>
> greetings
> jerzu

permalink · #3 (**permalink**) 02-28-2008, 07:12 AM

Dnia Tue, 13 Dec 2005 15:32:24 +0100, Markus Popp napisa³(a):

> Hi,
>
> If you have the SUPER privilege, you can do this with 'show processlist'
> (without the SUPER privilege, you will only see your connections).
I am root but I cant see all users in process list - I see only mine
processes

permalink · #4 (**permalink**) 02-28-2008, 07:12 AM

nousernospam wrote:
> Dnia Tue, 13 Dec 2005 15:32:24 +0100, Markus Popp napisa³(a):
>
>> Hi,
>>
>> If you have the SUPER privilege, you can do this with 'show processlist'
>> (without the SUPER privilege, you will only see your connections).
> I am root but I cant see all users in process list - I see only mine
> processes

In which case there are no users 'logged in'. If a user has a
connection and isn't doing anything it will still show up in the
processlist in the 'sleep' state.

--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png

permalink · #5 (**permalink**) 02-28-2008, 07:12 AM

On Tue, 13 Dec 2005 15:43:18 +0100, nousernospam wrote:
> Dnia Tue, 13 Dec 2005 15:32:24 +0100, Markus Popp napisa³(a):
>
>> Hi,
>>
>> If you have the SUPER privilege, you can do this with 'show processlist'
>> (without the SUPER privilege, you will only see your connections).
> I am root but I cant see all users in process list - I see only mine
> processes

root on the OS or root on the MySQL? The two aren't necessarily the same
thing. It's entirely possible to be running the mysql client as root,
but not be signed onto mysql as root.

--
Advocacy leads to disagreement; disagreement leads to Holy Wars; Holy
Wars lead to suffering. Advocacy is the first step on the road to the
kill-file.
-- Joe Zeff in the Monastery

permalink · #6 (**permalink**) 02-28-2008, 07:12 AM

"nousernospam" <nousernospam@wp.pl> wrote in message
news:15uo9g3gqezl0.12qv3p6ntduat$.dlg@40tude.net.. .
> I am root but I cant see all users in process list - I see only mine
> processes

Start a session in the "mysql" tool using another MySQL account in another
window. Then do show processlist again in your root MySQL session. Do you
see the additional account?

Regards,
Bill K.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode