And for emergencies when even the connection is stuck:
SHOW PROCESSLIST;
: Terminates both the running query and the entire client connection. mysql kill a query