Killing MySQL connections in batches

The following describes two methods for killing MySQL connections in batches. (1) information_schema.processlist [SQL] mysql> select concat ('kill', id ,';') from information_schema.processlist where user = 'root' into outfile'/tmp/killall.txt '; mysql> source/tmp/killall.txt; (ii) Use AWK In the Bash layer to implement ① kill all [SQL] mysqladmin-uroot-p processlist | awk-F "|" '{print $2}' | xargs-n 1 mysqladmin- uroot-p kill ② kill specified, for example: rocky [SQL] mysqladmin-uroot-p processlist | awk-F "|" '{if ($3 = "Rocky ") print $2} '| xargs-n 1 mysqladmin-uroot-p kill