How to Kill MySQL Queries

The command SHOW PROCESSLIST lists all the open connections to the server

 mysql> SHOW PROCESSLIST;

In order to kill a thread completely, use the KILL command followed by the thread ID returned by SHOW PROCESSLIST:

mysql> KILL 1234;