Kill a running query in mysql

If we are finding that we are struggling to connect to a MySQL database, it can be a result of a long running query and this can usually be terminated as follows;

Firstly, login to the MySQL database and run;

show processlist;

We can then kill the process bu the ID as follows;

kill id;

This can be verified bu again running show processlist; to ensure that the query has indeed been stopped.