update

如果从库出现问题,删除所有数据然后
RESET REPLICA;
START SLAVE;

主服务器
[mysqld]
server-id=1

CREATE USER 'replica'@'%' IDENTIFIED BY 'replica_password';
GRANT REPLICATION SLAVE ON *.* TO 'replica'@'%';
FLUSH PRIVILEGES;

从服务器
[mysqld]
server-id=2

CHANGE MASTER TO
MASTER_HOST='主服务器IP',
MASTER_USER='replica',
MASTER_PASSWORD='replica_password',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=0;
 
START SLAVE;

通过SHOW SLAVE STATUS\G;测试
注意开放端口