注：此处mysql安装 略

       此处使用mysql版本为5.7.1

• 主库创建用户并授权

CREATE USER 'test'@'localhost' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE,FILE ON *.* TO 'test'@'192.168.1.2' IDENTIFIED BY '123456';
flush privileges;

• 主库修改配置文件 my.ini

server-id=11
log_bin = mysql-bin
binlog-do-db=test #这个是需要同步的数据库 ，test是一个数据库，自行先创建

  show master status 查看是否成功

• 从库配置

CHANGE MASTER TO MASTER_HOST='192.168.10.11',MASTER_PORT=3306,MASTER_USER='test'
,MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000015',MASTER_LOG_POS=606;

#查看从库状态
start slave;
show slave status;

• 踩坑问题

[ERROR] Slave I/O for channel '': Fatal error: 
The slave I/O thread stops because master and slave have equal MySQL server UUIDs;these UUIDs must be different for replication to work

   mysql slave为copy过来的,导致uuid重复 修改后即同步完成