[系统运维]MYSQL多实例安装

给每个实例单独配置.cnf

vi /db1/mysql3307/my3307.cnf

[mysqld]
basedir = /db1/mysql3307
datadir = /db1/mysql3307/data
socket = /db1/mysql3307/mysql3307.socket
user = mysql
tmpdir = /db1/mysql3307
symbolic-links=0
log-bin = /db1/mysql3307/mysql-bin.log
pid-file = /db1/mysql3307/3307.pid
expire-logs-days = 14
port = 3307
max-binlog-size = 500M

server-id = 1
gtid-mode=on
enforce-gtid-consistency

[mysqld_safe]
log-error = /db1/mysql3307/data/error.log
pid-file = /db1/mysql3307/data/mysql.pid

[client]
port = 3307
socket = /db1/mysql3307/mysql3307.socket
初始化

bin/mysqld --defaults-file=/db1/mysql3307/my3307.cnf ?--user=mysql --basedir=/db1/mysql3307 --datadir=/db1/mysql3307/data ?--initialize
bin/mysqld --defaults-file=/db1/mysql3308/my3308.cnf ?--user=mysql --basedir=/db1/mysql3308 --datadir=/db1/mysql3308/data ?--initialize
bin/mysqld --defaults-file=/db2/mysql3309/my3309.cnf ?--user=mysql --basedir=/db2/mysql3309 --datadir=/db2/mysql3309/data ?--initialize
bin/mysqld --defaults-file=/db2/mysql3310/my3310.cnf ?--user=mysql --basedir=/db2/mysql3310 --datadir=/db2/mysql3310/data ?--initialize

添加环境变量
vi /etc/profile
export PATH=$PATH:/db1/mysql3307/bin
source /etc/profile

分别启动服务

/db2/mysql3310/bin/mysqld_safe --defaults-file=/db2/mysql3310/my3310.cnf ?&

指定defaults-file登录mysql

mysql --defaults-file=/db1/mysql3307/my3307.cnf -uroot -P3307 -p
mysql --defaults-file=/db1/mysql3308/my3308.cnf -uroot -P3308 -p

mysql --defaults-file=/db2/mysql3309/my3309.cnf -uroot -P3309 -p
mysql --defaults-file=/db2/mysql3310/my3310.cnf -uroot -P3310 -p

修改密码及权限

alter user root@'localhost' identified by 'M9Ncehx92haser3r8usxx1qaz!QAZ';

create user root@'%' identified by 'M9Ncehx92haser3r8usxx1qaz!QAZ';

grant all on *.* to root@'%';