Mysql kill user query's

We can easily kill all mysql queries to a specific user with elegant:

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

Substitute user123 with us users want and we implement in mysql and everything is OK 🙂

leave a reply

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

anti SPAM *