MySQL: Kill all queries / processes of certain user

by DXSdata | Jun 22, 2016 | MySQL | 0 comments

Open your MySQL client or phpMyAdmin etc.

Execute query:

select concat('KILL ',id,';') from information_schema.processlist where user='yourUser'

1	select concat('KILL ',id,';') from information_schema.processlist where user='yourUser'

Copy the result lines and execute them, it should look like:

kill 12345;
kill 12346;
kill 12347;
...

kill 12345;

kill 12346;

kill 12347;

...