how see connected user? - MySQL

[_mario.lat]

Hallo,
Some times my Db crash or say to many connections.
I'd like to see who cause that.
How can I see who is connected to mysql?
Thank you in advance for the time you'll spend for answering me.
Mario.

P.S. Any other suggestion is welcame!

[Axel]

"_mario.lat" <it> wrote:
 

As long as MySQL is up and you can log into it [1] you can use the
SHOW [FULL] PROCESSLIST command to see all open connections.

http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html


[1] MySQL reserves one connection for the superuser. So make sure
your application connects as non-superuser. Then you can connect
even if the database emits "too many connection" errors.

XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/