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

?

1 2 3 4 5 6 7 8 9 10 11 12

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';