Kill All MySQL Connections Based On Condition

This is a SQL snippet, talking about kill, connection and information_schema

Kill All MySQL Connections Based On Condition Add to Favorite

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

Kill All MySQL Connections Based On Condition

Created by ThePeppersStudio (47 days, 15.62 hours ago)

Do you want to leave a message? Please login first.