Mark, > Is there a way for root to kill a user's thread without using that > user's password?
You could use: mysql> SHOW PROCESSLIST; +----+-----------+-----------+------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------+-----------+------+---------+------+-------+------------------+ | 16 | superuser | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | | 17 | superuser | localhost | NULL | Sleep | 105 | | NULL | +----+-----------+-----------+------+---------+------+-------+------------------+ 2 rows in set (0.01 sec) mysql> SELECT CONNECTION_ID() /* better know your own thread ID */; +-----------------+ | CONNECTION_ID() | +-----------------+ | 16 | +-----------------+ 1 row in set (0.00 sec) mysql> KILL 17; Query OK, 0 rows affected (0.00 sec) Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
