虚拟机2台 192.168.164.101 192.168.164.104
101.创建用户并且给予权限 (如果设置简单密码需要修改下密码规则否则容易报错)
create user'libai'@'192.168.164.104'identified by '123123';
grant replication slave on *.* to "libai"@"192.168.164.104" identified by "123123";
101.创建ID vim /etc/my.cnf
server-id=1
log-bin=/var/lib/mysql/mysql-bin
101.重启服务
systemctl restart mysqld
101.登录mysql查看索引
show master status;
104.vim /etc/my.cnf 创建ID
server-id=2
relay-log=/var/lib/mysql/relay-bin
relay-log-index=/var/lib/mysql/relay-bin.index
104.重启mysql服务
104登录mysql
104配置主从信息
change master to master_h