I tried to kill query on AWS RDS today and I got an error saying “ERROR 1095 (HY000): You are not owner of thread” , even though I was using the admin account for RDS. As the error suggests, in order to kill it, you need to be the process owner. You can get the info from show processlist;
show processlist; +------+--------------+-------------------------------------------------+--------------+-------------+------+-----------------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------------+-------------------------------------------------+--------------+-------------+------+-----------------------------------------------------------------------+------------------+ | 4 | test | localhost:28368 | NULL | Sleep | 13 | | NULL |
In this example this query is running under user test. So you can login using user test and then you should be able to kill it. There might be a way to update the permissions for the admin user, but RDS is pretty locked down so I am not sure if AWS allows you to do that.
