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 🙂
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 🙂