Heidi SQL 'Cannot close tab with running query' I have a HeidiSQL query tab which I cannot close, where the execute button is greyed out.

I have searched for this and the recommendations are to show process list and then kill the queries found in it. However when I run show process list all it shows is the process list query itself. Also the status bar in the bottom right is Idle, which according to other answers I've read should mean nothing is running.

Any help would be appreciated.
Oh, dear, another case of a 3rd party software getting in the way.


Get a command window.
Open the "mysql" commandline tool.
SHOW PROCESSLIST;, identify the pid for the naughty query.
kill 1234; (or whatever the pid number is).


(If you were running the original query from "mysql", a simple CTRL-C would terminate it.  The above stuff would not be needed.)