mysql主从复制
主机器修改
server-id = 1
log_bin = mysql_bin
sync_binlog = 1
grant replication slave,replication client on *.* to abcd@'%' identified by '123456';
从机器修改
server-id = 11
relay_log = mysql-relay-bin
read_only = 1
reset slave;
change master to master_host='188.188.2.1',master_user='abcd',master_password='123456';
start slave;