MySQL批量杀死某个用户建立的连接

select concat('kill ', id, ';') as run_this
  from information_schema.processlist
 where user = 'root'
 into outfile '/tmp/kill_process.txt';

#info列表示执行特定sql的连接

select concat('kill ', id, ';') as run_this
  from information_schema.processlist
 where user = 'root'
   and info = 'select * from processlist'
   into outfile '/tmp/kill_process.txt';