主从同步

主库创建账户p, li { white-space: pre-wrap; }

grant replication slave on *.* to 'slave001'@'192.168.1.22' identified by 'slave001';

从库p, li { white-space: pre-wrap; }

change master to master_host='10.18.109.67', master_port=3306, master_user='slave001', master_password='123456',

MASTER_LOG_FILE='mysql-bin.000002',

MASTER_LOG_POS=0;