Active user sessions

[Cabbar Duzayak]

Hi,

Is there a way of listing all the active db sessions and their IP
addresses and/or db user names? Something like v$session in oracle?

Thanks...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Active user sessions

[Simon Garner]

On 31/10/2005 3:43 p.m., Cabbar Duzayak wrote:

Hi,

Is there a way of listing all the active db sessions and their IP
addresses and/or db user names? Something like v$session in oracle?

Thanks...



SHOW PROCESSLIST;

-Simon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]