Mysql Master主复制 [英] Mysql Master Master Replication

问题描述

服务器1:xxx.xxx.xxx.xxx

Server1: xxx.xxx.xxx.xxx

server-id=1 
binlog-do-db=sample 
master-host = xxx.xxx.xxx.xxx 
master-user = someuser 
master-password = somepassword 
master-connect-retry = 60 
relay-log = /var/lib/mysql/slave-relay.log 
relay-log-index = /var/lib/mysql/slave-relay-log.index 

服务器2:xxx.xxx.xxx.xxx

Server 2: xxx.xxx.xxx.xxx

server-id=2 
binlog-do-db = sample 
master-host = xxx.xxx.xxx.xxx 
master-user = someuser 
master-password = somepassword 
master-connect-retry = 60 
relay-log = /var/lib/mysql/slave-relay.log 
relay-log-index = /var/lib/mysql/slave-relay-log.index 

我已经在2个测试服务器上设置了主控主复制配置，我还为服务器上的mysql 3306都打开了端口，我正面临从属连接的问题，我一直在获得

I have setup the master master replication configuration on 2 test servers, i have also opened ports for both the mysql 3306 on servers i am facing a problem with slave connection I keep getting the

出现以下错误101021 19:12:23 [ERROR]从I/O:连接到主设备'[e-mail]:3306'时出错-重试时间:60次重试:86400，错误代码:1045

following errors 101021 19:12:23 [ERROR] Slave I/O: error connecting to master '[e-mail]:3306' - retry-time: 60 retries: 86400, Error_code: 1045

服务器1具有mysql 5.0.77，服务器2具有mysql版本5.1.41

Sever 1 has mysql 5.0.77 and server 2 has mysql version 5.1.41

推荐答案

错误代码:1045表示您的凭据有问题.

Error_code: 1045 means that there is a problem with your credentials.

尝试连接您的复制用户凭据，例如:

Try to connect with your replication user credentials like :

mysql -h host -u your_user -p your_password

请注意，密码限制为32个字符.

Note that the password is limited to 32 characters.

这篇关于Mysql Master主复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！