Mysql 主主复制
服务器1：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-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打开了端口从属连接我不断收到
以下错误 101021 19:12:23 [错误] 从属 I/O: 连接到主控时出错 '[电子邮件受保护]:3306' - 重试时间: 60 次重试: 86400, Error_code: 1045
服务器 1 具有 mysql 5.0.77，服务器 2 具有 mysql 版本 5.1。 41
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
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
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
following errors 101021 19:12:23 [ERROR] Slave I/O: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400, Error_code: 1045
Sever 1 has mysql 5.0.77 and server 2 has mysql version 5.1.41
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Error_code: 1045 表示您的凭据存在问题。
尝试使用您的复制用户凭据进行连接，例如：
请注意，密码不得超过 32 个字符。
Error_code: 1045 means that there is a problem with your credentials.
Try to connect with your replication user credentials like :
Note that the password is limited to 32 characters.