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.
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?