用 shell script 批次刪除 mysql process

把帳號 dbread 的連結全部砍光光

#!/bin/bash

user=dbmanger
pass=abc123

mysql -u $user -p $pass -e "show processlist;" > process.txt

for i in `cat process.txt|grep 'dbread'|awk '{print $1}'`
do
mysql -u $user -p $pass -e "kill $i;"
done