mysql5.7.14 windows主从配置简记

关键命令：

master:

SHOW MASTER STATUS;


SHOW PROCESSLIST;

FLUSH LOGS;

GRANT REPLICATION SLAVE ON *.* TO 'root'@'%' IDENTIFIED BY 'root';  
FLUSH PRIVILEGES;

slave:

SHOW SLAVE STATUS;
CHANGE MASTER TO
MASTER_HOST='localhost',
MASTER_PORT=3307,
MASTER_USER='root',
MASTER_PASSWORD='root',
MASTER_LOG_FILE='mysql-log-bin.000001',
MASTER_LOG_POS=154;


 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
 
 SHOW PROCESSLIST;  
 
 STOP SLAVE;
 
 START SLAVE;
 

备注：

master的server_id不能设为0