mysql 多实例开机自启动_MySQL5.7多实例安装及开机启动配置（亲测）

安装环境：

CentOS版本：CentOS7.6.1810

MySQL版本：5.7.9

以前一些很low的方法是，解压两个mysql，分别放到不同文件夹，其实在mysql中已经考虑到了多实例安装的情况。也有相应的脚本命令的支持。

现在安装两个mysql 一个3307，3308

新建 /etc/my.cnf 配置如下：

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

user = root #登陆数据库用户

password = root1234% #登陆数据库密码，用于关闭数据库，两台数据库密码设置一样

[mysqld1]

user = mysql

port = 3307

socket = /tmp/mysql3307.sock

pid-file = /usr/local/mysql/data3307/mysql.pid

datadir = /usr/local/mysql/data3307

language = /usr/local/mysql/share/mysql/english

log_error = 3307_error.log

[mysqld2]

user = mysql

port = 3308

socket = /tmp/mysql3308.sock

pid-file = /usr/local/mysql/data3308/mysql.pid

datadir = /usr/local/mysql/data3308

language = /usr/local/mysql/share/mysql/english

log_error = 3308_error.log

创建两个数据目录：

mkdir /usr/local/mysql/data3307

mkdir /usr/local/mysql/data3308

chown mysql.mysql /data{3307…3308}

数据库初始化：

mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data3307

mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data3308