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