Mysql user kill privilege

Hiya

I got a request from a client for the rights to kill his queries if something goes wrong. Long story short, he doesn't want to have to phone.

I see via the MySQL documentation, that the client would need PROCESS and SUPER privileges. Im not happy with that.

Would know of an alternative solution. I could reply, write better queries, but somehow I dont think the client would be to happy with that.

Kind Regards
Brent Clark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql user kill privilege

> I got a request from a client for the rights to kill his queries if
> something goes wrong. Long story short, he doesn't want to have to phone.
>
> I see via the MySQL documentation, that the client would need PROCESS and
> SUPER privileges. Im not happy with that.
>
> Would know of an alternative solution. I could reply, write better queries,
> but somehow I dont think the client would be to happy with that.

A user can always kill his own queries. As long as he can have 2 simultaneous
connections or more, killing his own queries should be simple.

http://dev.mysql.com/doc/refman/5.1/en/kill.html
"If you have the PROCESS privilege, you can see all threads. If you have the
SUPER privilege, you can kill all threads and statements. Otherwise, you can
see and kill only your own threads and statements."
--
Rik Wasmus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org