环境:两台PC上面装mysql 5.6版本
[主服务器:192.168.6.1]
mysql>GRANT REPLICATION SLAVE ON *.* TO ‘slave_user’@’%’ IDENTIFIED BY ‘‘123456; (按需设置用户名和密码!)
mysql>FLUSH PRIVILEGES;
mysql>FLUSH TABLES WITH READ LOCK;
mysql>SHOW MASTER STATUS;
# 此外需要备份数据库,比如: mysqldump -u root -p test > test.sql .
mysql>UNLOCK TABLES;
[主服务器:192.168.6.100]
# 导入DB: mysql -u root -p test < test.sql
mysql>stop slave;
mysql>CHANGE MASTER TO MASTER_HOST='192.168.6.1', MASTER_USER='lzq', MASTER_PASSWORD='123456', MASTER_LOG_FILE='bin-log.000001', MASTER_LOG_POS=120; MASTER_LOG_POS=33421;
mysql>start slave;
以上,完成后可以进行测试,比如在主数据库插入一条新数据,然后分别在主和从上面select出来,确认OK.