How can I stop a running MySQL query?

I connect to mysql from my Linux shell. Every now and then I run a SELECT query that is too big. It prints and prints and I already know this is not what I meant. I would like to stop the query.

Hitting Ctrl+C (a couple of times) kills mysql completely and takes me back to shell, so I have to reconnect.

Is it possible to stop a query without killing mysql itself?

mysql>show processlist;

kill "number from first col";

Posts to Review:

How to convert all tables from MyISAM into InnoDB? MYSQL Partitioning : What is and HOW To ? Change default MySQL Data Directory in Linux Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.