Mysql主从同步简单配置_MySQL
2020-11-09
来源：乌哈旅游
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
显示全文