mysql-kill.sh

#!/bin/bash

MYSQL_CONN="-uUSER -pPASS";
USERS="'user1','user2','usern'"

mysql ${MYSQL_CONN} -e "select concat('KILL ',id,';') from information_schema.processlist 
                        where user IN (${USERS}) \
                        into outfile '/tmp/sleep_processes.txt'; \
                        source /tmp/sleep_processes.txt;"; \
                        rm -rf /tmp/sleep_processes.txt