mysql 啟動、重啟、kill腳本

vi mysql

#!/bin/sh????????
mysql_port=3306????????
mysql_username="root"????
mysql_password=""????
????
start_mysql()????????
{????????
????????printf "Starting MySQL...\n"????
????????/bin/sh /data1/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf 2>&1 > /dev/null &????????
}????????
????
stop_mysql()????????
{????????
????????printf "Stoping MySQL...\n"????
????????/data1/mysql/bin/mysqladmin -u ${mysql_username}????-S /tmp/mysql.sock shutdown????????
}????????
????
restart_mysql()????????
{????????
????????printf "Restarting MySQL...\n"????
????????stop_mysql????????
????????sleep 5????????
????????start_mysql????????
}????????
????
kill_mysql()????????
{????????
????????kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep 'my.cnf' | awk '{print $2}')????????
????????kill -9 $(ps -ef | grep 'libexec/mysqld'????| grep 'my.cnf' | awk '{print $2}')????????
}????????
????
if [ "$1" = "start" ]; then????????
????????start_mysql????????
elif [ "$1" = "stop" ]; then????????
????????stop_mysql????????
elif [ "$1" = "restart" ]; then????????
????????restart_mysql????????
elif [ "$1" = "kill" ]; then????????
????????kill_mysql????????
else????
????????printf "Usage: /app/mysql {start|stop|restart|kill}\n"????
fi????

轉載于:https://blog.51cto.com/cqfish/166268

總結

以上是生活随笔為你收集整理的mysql 启动、重启、kill脚本的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。