() pri fault php highlight pwd brush awk admin
1.
- #init port = 3306 mysql_user = "root"mysql_pwd = "cancer"CmdPath = "/application/mysql/bin"mysql_sock = "/data/${port}/mysql.sock"
- #startup
- function function_start_mysql() {
- if [!-e "$mysql_sock"];
- then printf "Starting MySQL...\n" / bin / sh $ {
- CmdPath
- }
- /mysqld_safe --defaults-file=/data / $ {
- port
- }
- /my.cnf 2>&1 > /dev / null &
- else printf "MySQL is running...\n"exit fi
- }
- #stop
- function function_stop_mysql() {
- if [!-e "$mysql_sock"];
- then printf "MySQL is stopped...\n"exit
- else printf "Stoping MySQL...\n"$ {
- CmdPath
- }
- /mysqladmin -u ${mysql_user} -p${mysql_pwd} -S /data / $ {
- port
- }
- /mysql.sock shutdown
- fi
- }
- #restart function
- function_restart_mysql()
- {
- printf "Restarting MySQL...\n"
- function_stop_mysql
- sleep 2
- function_start_mysql
- }
- case $1 in
- start)
- function_start_mysql
- ;;
- stop)
- function_stop_mysql
- ;;
- restart)
- function_restart_mysql
- ;;
- *)
- printf "Usage: /data / $ {
- port
- }
- /mysql {start|stop|restart}\n"
- esac/
http://blog.csdn.net/u011364306/article/details/47814409
2.
- # ! /bin/bash mysql_port = 3307 mysql_username = "admin"mysql_password = "password"function_start_mysql() {
- printf "Starting MySQL...\n" / bin / sh / usr / local / mysql / bin / mysqld_safe--defaults - file = /data/dbdata_$ {
- mysql_port
- }
- /my.cnf 2>&1 > /dev / null &
- }
- function_stop_mysql() {
- printf "Stoping MySQL...\n" / usr / local / mysql / bin / mysqladmin - u $ {
- mysql_username
- } - p$ {
- mysql_password
- } - S / data / dbdata_$ {
- mysql_port
- }
- /mysql.sock shutdown
- }
- function_restart_mysql()
- {
- printf "Restarting MySQL...\n"
- function_stop_mysql
- 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
- }‘)
- }
- case $1 in start) function_start_mysql;;stop) function_stop_mysql;;kill) function_kill_mysql;;restart) function_stop_mysql function_start_mysql;; * ) echo "Usage: /data/dbdata_${mysql_port}/mysqld {start|stop|restart|kill}";;esac
http://blog.csdn.net/zhoufoxcn/article/details/73065655?utm_source=tuicool&utm_medium=referral
Mysql多实例之mysql服务脚本
来源: http://www.bubuko.com/infodetail-2349681.html