linux脚本执行mysql命令

创建脚本文件

[root@mihaoyu151 opt]# vi ./opmysql.sh

脚本内容

#!/bin/bash
cat<<EOF
"欢迎来到mysql操作脚本，请输入相应数字进行操作"
"1   start mysql"
"2   stop mysql"
"3   restart mysql"
"4   show mysql status"
EOF
while true
do
	read -p "请输入数字：" op
	case $op in
	1)
		echo "启动mysql服务"
		systemctl start mysqld
	;;
	2)
		echo "关闭mysql服务"
		systemctl stop mysqld
	;;
	3)
		echo "重启mysql服务"
		systemctl stop mysqld
		systemctl start mysqld
	;;
	4)
		echo "查看mysql服务状态"
		systemctl status mysqld
	;;
	*)
		echo "退出当前程序"
		exit 0;
	;;
	esac
done

赋予执行权限

[root@mihaoyu151 opt]# chmod +x ./opmysql.sh

执行脚本

[root@mihaoyu151 opt]# ./opmysql.sh