mysql 启动脚本_mysql启动脚本-my

#!/bin/sh

PREFIX=/opt/mysql

mysql_username="root"mysql_password="123456"mysql_port=3308function_start_mysql()

{

printf"Starting MySQL...\n"

/bin/sh $PREFIX/bin/mysqld_safe --defaults-file=$PREFIX/conf/my${mysql_port}.cnf 2>&1 > /dev/null &}

function_stop_mysql()

{

printf"Stoping MySQL...\n"$PREFIX/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /tmp/my${mysql_port}.sock shutdown

}

function_restart_mysql()

{

printf"Restarting MySQL...\n"function_stop_mysql

sleep5function_start_mysql

}

function_kill_mysql()

{

kill-9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')

kill-9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')

}if [ "$1" = "start"]; then

function_start_mysql

elif ["$1" = "stop"]; then

function_stop_mysql

elif ["$1" = "restart"]; then

function_restart_mysql

elif ["$1" = "kill"]; then

function_kill_mysqlelseprintf"Usage: $0 {start|stop|restart|kill}\n"fi

#!/bin/sh

PREFIX=/opt/mysql

mysql_username="root"

mysql_password="123456"

mysql_port=3308

function_start_mysql()

{

printf "Starting MySQL...\n"

/bin/sh $PREFIX/bin/mysqld_safe--defaults-file=$PREFIX/conf/my${mysql_port}.cnf 2>&1 > /dev/null &

}

function_stop_mysql()

{

printf "Stoping MySQL...\n"

$PREFIX/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /tmp/my${mysql_port}.sock shutdown

}

function_restart_mysql()

{

printf "Restarting MySQL...\n"

function_stop_mysql

sleep 5

function_start_mysql

}

function_kill_mysql()

{

kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')

kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')

}

if [ "$1" = "start" ]; then

function_start_mysql

elif [ "$1" = "stop" ]; then

function_stop_mysql

elif [ "$1" = "restart" ]; then

function_restart_mysql

elif [ "$1" = "kill" ]; then

function_kill_mysql

else

printf "Usage: $0 {start|stop|restart|kill}\n"

fi