patternsqlMinor
mysql privilege to kill processes of other users
Viewed 0 times
killprivilegeusersmysqlprocessesother
Problem
I have a percona mysql database. The version is 5.5.29-29.4-log.
I have created a user called admin which should be able to kill processes initiated by other users, i.e worker.
It does had the process privilege, which I thought would do the trick. But, I can see this error
Would anyone be able to help?
I have created a user called admin which should be able to kill processes initiated by other users, i.e worker.
GRANT SELECT, INSERT, UPDATE, DELETE, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON *.* TO 'admin'@'ip_' IDENTIFIED BY PASSWORD 'password';It does had the process privilege, which I thought would do the trick. But, I can see this error
/* SQL Error (1095): You are not owner of thread 7480126 */Would anyone be able to help?
Solution
From here
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.
You can also use the mysqladmin processlist and mysqladmin kill
commands to examine and kill threads.
See here for privilege granting - search for SUPER.
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.
You can also use the mysqladmin processlist and mysqladmin kill
commands to examine and kill threads.
See here for privilege granting - search for SUPER.
Context
StackExchange Database Administrators Q#73212, answer score: 8
Revisions (0)
No revisions yet.