第三节：mysql5.6多实例环境下脚本_mysql 端口下的startup.sh-优快云博客

本文提供了一套针对多实例MySQL服务器的操作脚本，包括启动、关闭及登录脚本。这些脚本支持不同端口的MySQL实例，并通过输入端口号来区分不同的实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.多实例mysql启动脚步
vi /mysql01/mysqlstartup.sh
#!/bin/bash
#多实例mysql启动脚本：mysqlstartup.sh
#请输入启动实例端口号
read -p "please input the port number:" port
portA='3306'
portB='3307'
echo "mysql${port} is starting up"
if [ $port == $portA ];then
/mysql01/my3306/bin/mysqld_safe --defaults-file=/mysql01/my3306/my.cnf --user=mysql
        elif [ $port == $portB ];then
/mysql01/my3307/bin/mysqld_safe --defaults-file=/mysql01/my3307/mytwo.cnf --user=mysql
        else
        echo "Can't startup! please ensure the port!"
fi
chmod 744 mysqlstartup.sh
vi /mysql01/mysqlstop.sh
2.多实例mysql关闭脚步
#!/bin/bash
#多实例mysql关闭脚步：mysqlstop.sh
read -p "please input the port number:" port
portA='3306'
portB='3307'
echo "mysql${port} is starting up"
if [ $port == $portA ];then
MYSQL_USER='system'
MYSQL_PASS='my3306pwd'
/mysql01/my3306/bin/mysqladmin -u${MYSQL_USER} -p${MYSQL_PASS} -S /mysql01/my3306/run/mysql.sock shutdown
        elif [ $port == $portB ];then
MYSQL_USER='admin'
MYSQL_PASS='my3307pwd'
/mysql01/my3307/bin/mysqladmin -u${MYSQL_USER} -p${MYSQL_PASS} -S /mysql01/my3306/run/mysql.sock shutdown
        else
        echo "Can't shutdown! please ensure your parametes!"
fi
chmod 744 mysqlstop.sh
3.登录mysql服务器脚步
vi /mysql01/mysqlplus.sh
#!/bin/bash
#多实例mysql登录脚步：mysqlplus.sh
read -p "please input the port number:" port
portA='3306'
portB='3307'
echo "mysql${port} is starting up"
if [ $port == $portA ];then
MYSQL_USER='system'
MYSQL_PASS='my3306pwd'
/mysql01/my3306/bin/mysql -u${MYSQL_USER} -p${MYSQL_PASS} -P${port}
        elif [ $port == $portB ];then
MYSQL_USER='admin'
MYSQL_PASS='my3307pwd'
/mysql01/my3307/bin/mysql -u${MYSQL_USER} -p${MYSQL_PASS} -P${port}
        else
        echo "Can't login! please ensure your parametes!"
fi
chmod 744 mysqlplus.sh

学习笔记，仅供参考！欢迎指正