Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm

Links

XODOX
Impressum

#1: Mysql user kill privilege

Posted on 2011-09-27 12:46:02 by Brent Clark

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

Report this message

#2: Re: Mysql user kill privilege

Posted on 2011-09-27 12:55:19 by Rik Wasmus

> 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

Report this message