GRANT REPLICATION SLAVE ON *.* to 'root'@'111.111.111.111' identified by '123456'; flush privileges;
CREATE USER 'root'@'111.111.111.111' IDENTIFIED WITH mysql_native_password BY '123456'; GRANT REPLICATION SLAVE ON *.* TO 'root'@'222.222.222.222';
$ service mysqld restart
$ show master status
#mysql唯一id
server-id = 1
#二进制日志文件,此项为必填项,否则不能同步数据;
log-bin = "mysql-bin"
#指定二进制错误文件
log-error="mysql-error"
#需要同步的数据库,如果需要同步多个数据库;
binlog-do-db = demo
#binlog-do-db = slaveDB1
#binlog-do-db = slaveDB2
#不需要同步的数据库
binlog-ignore-db = mysql
change master to master_host='111.111.111.111', master_user='root', master_password='123456', master_log_file='mysql-bin.000001', master_log_pos=154;
$ start slave;
server-id=2 #默认是1改成2
log-bin="mysql-bin" #这行本身有
replicate-do-db=demo #需要同步的数据库
replicate-ignore-db=mysql #不同步系统数据库
read_only #设只读权限
其中Slave_IO_Running 与 Slave_SQL_Running 的值都必须为YES,才表明状态正常
$ stop slave
$ show slave status\G