首先要查询mysql导出的目录路径
1. show global variables like '%secure_file_priv%';
2. mysql> SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='xxxx' INTO OUTFILE '/var/lib/mysql-files/killlist.txt';
3.mysql> source /var/lib/mysql-files/killlist.txt;