# 注意以下所填写的ip地址为从库的ip地址
CREATE USER 'repl'@'192.168.154.111' IDENTIFIED BY '123456';
grant replication slave on *.* to 'repl'@'192.168.154.111';
4.查看MASTER_LOG_FILE和MASTER_LOG_POS
show master status;
5.从库执行,MASTER_LOG_FILE和MASTER_LOG_POS为上述所查出来的值。
CHANGE MASTER TO MASTER_HOST='192.168.154.112',MASTER_USER='repl',MASTER_PASSWORD='123456',MASTER_PORT=3306,MASTER_LOG_FILE='mysql-bin.000311',MASTER_LOG_POS=35197643,get_master_public_key=1;
6.从库启动复制进程
start slave;
7.查看从库状态信息
show slave status \G
# 执行成功后查看Slave_IO_Running和Slave_SQL_Running字段是否都为“YES”,如果是则配置成功。