AZURE MYSQL:::Amazon RDS::How do I kill a process in MySQL running within Azure MYSQL or Amazon RDS?

How do I kill a process in MySQL running within Azure MYSQL or Amazon RDS?

As root, I’m trying to kill a transaction that’s locking some tables. I run

KILL 1711;

/* SQL Error (1095): You are not owner of thread 1711 */

Received above error.

Solution:

If you are using RDS MySQL you can use rds_kill() procedure or using Azure MySQL , you can use az_kill() , as the following example:

Connect to MySQL

List process:

SHOW FULL PROCESSLIST;

In my case, I want to kill the process of id 1711:

CALL mysql.rds_kill(1711);

or 

CALL mysql.az_kill(1711);

Done