Use mysqladmin to kill the runaway query:

Run the following commands:

mysqladmin -uusername -ppassword pr


Then note down the process id.

mysqladmin -uusername -ppassword kill pid


The runaway query should no longer be consuming resources.

How can I stop a running MySQL query?
Is there a more colloquial term for a "confidant", or someone who has been entrusted with sensitive information to be disclosed only under certain conditions?

This is related to my previous question on trusted proxies.
