mysql8 主从同步设置

 

 

 

主库
server-id=2
CREATE USER 'shabi'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT replication slave ON *.* TO 'slave'@'%';
GRANT ALL privileges ON *.* TO 'slave'@'%';

SHOW MASTER STATUS;


从库
stop slave ;
change master to master_host='192.168.10.21',master_user='shabi',master_password='123456',master_log_file='mysql-bin.000069' ,master_log_pos=2082183;
start slave ;