MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:September 27 2011 10:55am
Subject:Re: Mysql user kill privilege
View as plain text  
> 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.
"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 user kill privilegeBrent Clark27 Sep
  • Re: Mysql user kill privilegeRik Wasmus27 Sep