MySQL启停脚本

port=3306
mysql_user="mysql"
Cmdpath="/application/mysql-5.6.49-linux-glibc2.12-x86_64/bin"
mysql_sock="/MySQL/${port}/mysql.sock"
mysqld_pid_file_path=/MySQL/${port}/mysqld_${port}.pid
start(){
if [ ! -e "$mysql_sock" ];then
    printf "starting MysoL...\n"
    /bin/sh ${Cmdpath}/mysqld_safe --defaults-file=/MySQL/3306/my.cnf --pid-file=$mysqld_pid_file_path 2>&1 > /dev/null &
    sleep 3
else
    printf "MySQL is running...\n"
    exit 1
fi
}

stop(){
if [ ! -e "$mysql_sock" ];then
   printf "MySQL is stopped\n"
   exit 1
else
    printf "Stoping MySQL...\n"
    mysqld_pid=`cat "$mysqld_pid_file_path`
    if (kill -0 $mysqld_pid 2>/dev/null)
        then
            kill $mysqld_pid
        sleep 2
    fi
fi
}

restart(){
    printf "正在重启MySQL"
    stop
    sleep 2
    start
}
case "$1" in
start)
    start
;;
stop)
    stop
;;
restart)
    restart
;;
*)
    printf "使用方法：mysql（start|stop|restart)\n"
esac