mysql主从配置

主库配置：

master的标示

server-id=203

slave会基于此log-bin来做replication

log-bin=mysql-bin

用于master-slave的具体数据库

binlog-do-db=test

不用于master-slave的具体数据库

binlog_ignore_db=mysql

和binlog-do-db一样，可以设置多个

binlog_ignore_db=information_schema

主库命令行

CREATE USER ‘copy’@‘192.168.116.43.%’ IDENTIFIED BY ‘copy123456’;

GRANT REPLICATION SLAVE ON . TO ‘copy’@’%’;

grant replication slave on . to repl@‘192.168.116.43.%’ identified by ‘strong’

flush privileges;

show master status;

从数据库命令行：

change master to master_host=‘10.0.0.239’,master_port=7999,master_user=‘copy’,master_password=‘copy123456’,master_log_file=‘mysql-bin.000003’,master_log_pos=1762;

show slave status

start slave

stop slave

参考https://blog.csdn.net/sinat_33909283/article/details/89220140