GRANT REPLICATION SLAVE ON *.* TO 'backup'@'192.168.0.2' IDENTIFIED BY '123';
修改my.cnf文件:
[mysqld]
log-bin
server-id=1
#master部分
sql-bin-update-same
binlog-do-db= test
#slave部分
master-host=192.168.0.2
master-user=backup
master-password=123
master-port=3306
server-id=2
master-connect-retry=60
replicate-do-db=testdatabase [要更新的数据库]
log-slave-updates |