how to see users logged into mysql?

[nousernospam]

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

greetings
jerzu

[Markus Popp]

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

[nousernospam]

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 :(

[Brian Wakem]

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: [url]http://homepage.ntlworld.com/b.wakem/myemail.png[/url]

[Bill Karwin]

"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.