| KILL 3101; |
2 rows in set (0.00 sec)
mysql> select concat(
'KILL ',id,
';') from information
_schema.processlist where user='root' into outfile '/tmp/a.txt';
Query OK, 2 rows affected (0.00 sec)
mysql> source /tmp/a.txt;
Query OK, 0 rows affected (0.00 sec)
参考Mass killing of MySQL Connections
查找可导出路径
show variables like '%secure%';查看 secure-file-priv 当前的值是什么
参考