rushipkar90 · September 25, 2015 16:54
diff --git a/mysqlkilluser.sh b/mysqlkilluser.sh
 #!/bin/bash
 if [[ $1 != "" ]]
 then
    for p in `mysqladmin proc stat | grep $1 | awk '{print $2}'`
    do
            mysqladmin kill $p
    done
 else
    echo "Usage: mysqlkilluser.sh <user>"
 fi
	#!/bin/bash
	if [[ $1 != "" ]]
	then
	for p in `mysqladmin proc stat \| grep $1 \| awk '{print $2}'`
	do
	mysqladmin kill $p
	done
	else
	echo "Usage: mysqlkilluser.sh <user>"
	fi