MySQL主从复制
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;
server-id=1
log-bin=mysql-bin
binlog_do_db=test
GRANT REPLICATION SLAVE ON *.* to 'test'@'10.0.0.6' identified by '123456';
change master to master_host='10.0.0.7',
master_port=3306,
master_user='slave',
master_password='XeDUMevzoigvx3c7',
master_log_file='master-bin.000001',
master_log_pos=0;
start slave
show slave status