Mysql主从同步简单配置_MySQL

来源：动视网责编：小采时间：2020-11-09 19:23:57

Mysql主从同步简单配置_MySQL

Mysql主从同步简单配置_MySQL://master log-bin=mysql-binserver-id=222 //创建同步帐号GRANT REPLICATION SLAVE ON *.* to 'mysync'@'172.168.16.105' identified by 'test' //slave server-id=221 change master to master_h

推荐度：

点击下载本文 文档为doc格式

导读Mysql主从同步简单配置_MySQL://master log-bin=mysql-binserver-id=222 //创建同步帐号GRANT REPLICATION SLAVE ON *.* to 'mysync'@'172.168.16.105' identified by 'test' //slave server-id=221 change master to master_h

//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

Mysql主从同步简单配置_MySQL

推荐度：

点击下载本文 文档为doc格式

标签：同步简单配置

热门焦点

Mysql主从同步简单配置_MySQL

Mysql主从同步简单配置_MySQL

Mysql主从同步简单配置_MySQL

最新推荐

猜你喜欢

热门推荐