MySQL主从复制配置

A: 192.168.3.81 作为master，没有数据
B: 192.168.3.82  作为slave，没有数据

vim /etc/my.conf

[mysqld]
log-bin=mysql-bin 
server-id=1  

systemctl restart mysqld

mysql -uroot -p

grant replication slave on *.* to 'slave'@'192.168.3.82' identified by '123456'; 

show master status;

vim /etc/my.conf

log-bin=mysql-bin
server-id=2

systemctl restart mysqld

mysql -uroot -p

change master to master_host='192.168.3.81',master_user='slave',master_password='123456',master_log_file='mysql-bin.000001' ,master_log_pos=651;

set global super_read_only=1;

mysql> start slave;

mysql> show slave status\G