Mysql5.7多实例配置

> mkdir -p /usr/local/mysql/data/{3306,3307}

> vim /etc/my3306.cnf
[client]

socket=/usr/local/mysql/data/3306/mysql.sock
[mysqld]

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data/3306
socket=/usr/local/mysql/data/3306/mysql.sock

port=3306
binlog-do-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=mysql
binlog-ignore-db=sys

expire_logs_days=7
log-bin=mysql3306-bin

server-id=110
log-error=/usr/local/mysql/data/3306/error.log
[mysqld_safe]
log-error=/usr/local/mysql/data/3306/mysql.log
pid-file=/usr/local/mysql/data/3306/mysql.pid

> vim /etc/my3307.cnf
[client]

socket=/usr/local/mysql/data/3307/mysql.sock
[mysqld]

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data/3307
socket=/usr/local/mysql/data/3307/mysql.sock

port=3307


log-bin=mysql-3307bin
server-id=111
read-only=1
master_info_repository=TABLE
relay_log_info_repository=TABLE
log-error=/usr/local/mysql/data/3307/error.log
[mysqld_safe]
log-error=/usr/local/mysql/data/3307/mysql.log
pid-file=/usr/local/mysql/data/3307/mysql.pid

> /usr/local/mysql/bin/mysqld --user=mysql 
--basedir=/usr/local/mysql 
--datadir=/usr/local/mysql/data/3306 --initialize

> /usr/local/mysql/bin/mysqld --user=mysql 
--basedir=/usr/local/mysql 
--datadir=/usr/local/mysql/data/3307 --initialize

> vim /etc/systemd/system/mysql3306.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
LimitNOFILE = 10000
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my3306.cnf 

> vim /etc/systemd/system/mysql3307.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
LimitNOFILE = 10000
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my3307.cnf 

> systemctl daemon-reload
> systemctl start mysql3306
> systemctl start mysql3307
//查看mysql状态
> systemctl status mysql3306
> systemctl status mysql3307

> mysql -uroot -p -S /usr/local/mysql/data/3306/mysql.sock

> mysql -uroot -p -S /usr/local/mysql/data/3307/mysql.sock

> alter user 'root'@'localhost' identified by '123456';
> flush privileges;