[:de]MySQL: Alle Abfragen / Prozesse eines bestimmten Benutzers beenden[:en]MySQL: Kill all queries / processes of certain user[:]

Last Updated on 2016-06-22.

[:en]Open your MySQL client or phpMyAdmin etc.

Execute query:

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;
...

Reference[:]