I do have logged in with a mysql user easypay who has all privileges on a DB easypay and was executing the command
show engine innodb status
Mysql gave error as
[Error Code: 1227, SQL State: 42000] Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
Even though grant all permission on the specified I was getting error.
GRANT SELECT, PROCESS ON *.* TO 'easypay'@'localhost';
and your troubles should be over.
If you have the PROCESS privilege for all DB(s), 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.