快捷启动、停止、重启、杀死指定端口MySQL进程的sh脚本

╰半橙微兮° 2022-06-16 23:19 225阅读 0赞

写了一个shell脚本，可以在同一台Linux服务器的不同端口，运行多个MySQL服务的情况下，快捷启动、停止、重启、杀死指定端口的MySQL进程。

vi /usr/local/bin/mysql.sh

输入以下内容（因各服务器的MySQL配置不同，可能需要修改的部分已用红色标注）：

\#!/bin/sh  
  
mysql\_port=$2  
mysql\_username=" root"  
mysql\_password=" 123456"  
  
function\_start\_mysql()  
\{  
    printf "Starting MySQL...\\n"  
    /bin/sh /usr/local/mysql/bin/mysqld\_safe \--defaults-file= /mysql/$\{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\} -h localhost \-P $\{mysql\_port\} 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\}')  
\}  
  
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: mysql.sh \{start|stop|restart|kill\}\\n"  
fi

赋予脚本可执行权限：

chmod +x /usr/local/bin/mysql.sh

脚本执行方法：

mysql.sh start 3306  
mysql.sh stop 3306  
mysql.sh restart 3306

原文： [http://blog.s135.com/post/359/][http_blog.s135.com_post_359]\]  
  
mysql.sh kill 3306

[http_blog.s135.com_post_359]: http://blog.s135.com/post/359/