Mysql 主从同步简单配置_MySQL

//master

log-bin=mysql-bin
server-id=222

//创建同步帐号
GRANT REPLICATION SLAVE ON *.* to 'mysync'@'172.168.16.105' identified by 'test'

//slave

server-id=221

change master to master_host='192.168.130.198',master_user='sync',master_password='yLGxdSTwmY',master_log_file='mysql-bin.000022',master_log_pos=107;
start slave