1、先在主从数据库上新建同名数据库cp(同步数据库)
2、在主库文件夹的my.ini文件的mysqld节点添加如下
server-id = 3333
log-bin = mysql3306-bin
binlog-do-db = cp
binlog-ignore-db = mysql
binlog-ignore-db = infomation_schema
binlog-ignore-db = performance_schema
binlog-ignore-db = test
3、修改从库的my.ini配置
server-id = 77
log-bin = mysql3306-bin
replicate-do-db = cp
4、重启主从数据库的服务
5、主库设置一个供从库访问的账户
grant replication slave on *.* to repl@127.0.0.1 identified by '123456' ;
flush privileges;
其中repl是账号,123456是密码,127.0.0.1指定账户ip
6、主库查看master状态,记录下file和position对应的值,从库设置需用到
6、从库设置
change master to master_host='127.0.0.1',master_user='repl',master_password='123456', master_log_file='mysql-bin.000001',master_log_pos=572735;
start slave;
查看从库是否设置成功:
show slave status;
其中slave_io_running:yes,slave_sql_running:yes,否则主从配置失败。