您好,欢迎访问一九零五行业门户网

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
其它类似信息

推荐信息