[root@mariadb-cluster-1 ~]# cat 1.sh
#!/bin/bash
# name: mysql_kill_session
# variable
list_kill_user=$1
file_output_sql=mysql_kill_session.output
mysql_user="root"
mysql_password="****"
# display
echo "User will be killed: $list_kill_user"
echo "-------------------------"
# begin
echo "" > $file_output_sql
for item_user in $list_kill_user
do
echo "Current User is: $item_user"
#echo "-------------------------"
#mysql -u"$mysql_user" -p"$mysql_password" -e 'show processlist;'
echo "-------------------------"
mysql -u"$mysql_user" -p"$mysql_password" -N -e "select concat('kill ',id,';') from information_schema.processlist where user in ('$item_user');" >> $file_output_sql
done
echo ""
# Result:
echo "-------------------------"
echo "Result is:"
cat $file_output_sql
# finished
[root@mariadb-cluster-1 ~]#