Mysql kill user query’s

We can easily kill all mysql requests of a certain user with the elegant one:

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

We replace user123 with the user we want and run in mysql and everything is OK 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

Anti SPAM *