Posted By

r0b0tnic on 01/26/10


Tagged


Versions (?)

Kill all MySQL connections based on condition


 / Published in: MySQL
 

  1. SHOW processlist;
  2. SELECT CONCAT('KILL ',id,';') FROM information_schema.processlist WHERE user='root';

Report this snippet  

You need to login to post a comment.