1.主库 /etc/my.cnf增加如下配置
binlog-do-db=test
binlog-ignore-db=mysql
log-bin=mysql-bin
server-id=129
2.从库etc/my.cnf增加如下配置
server-id=130
replicate-do-db=test
replicate-ignore-db=mysql
3.主节点创建公共用户并授权
mysql -uroot -p123456
create user 'test'@'%'identified with mysql_native_password by '123456';
grant all privileges on . to 'test'@'%' with grant option;

flush privileges;

4.查看状态，可以看当前主库当前同步日志的信息
show master status;
5.从节点对master的配置，根据上一步的配置
mysql -uroot -p123456
CHANGE MASTER TO

     MASTER_HOST='182.92.172.80',
     MASTER_USER='test',
     MASTER_PASSWORD='123456',
     MASTER_LOG_FILE='mysql-bin.000003',
     MASTER_LOG_POS=73;

6.开启同步并显示状态
开启同步
start slave;
关闭同步
stop slave;
显示状态
show slave status\G