[ERROR] Slave I/O: error connecting to master

最新推荐文章于 2023-01-09 21:07:19 发布

weixin_34306676

最新推荐文章于 2023-01-09 21:07:19 发布

阅读量867

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：https://yq.aliyun.com/articles/43337

在配置MySQL主从复制时遇到Slave_IO_Running显示Connecting的问题，错误日志显示连接主服务器失败。解决方法包括检查网络、确认密码、校准log_pos，并提供了解决网络不通、密码错误和pos不正确等常见问题的步骤，以及如何通过mysqlbinlog工具定位并修正binlog位置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

刚配置的MySQL主从，在从机上看到
点击(此处)折叠或打开
mysql> SHOW slave STATUS \\G
*************************** 1. row ***************************
               Slave_IO_State: Connecting to master
                  Master_Host: 172.17.210.199
                  Master_User: my
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: masters-bin.000003
          Read_Master_Log_Pos: 1224
               Relay_Log_File: testmysql-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: masters-bin.000003
             Slave_IO_Running: Connecting
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
看日志有很多：
点击(此处)折叠或打开
141010 0:02:48 [ERROR] Slave I/O: error connecting to master \'my@172.17.210.199:3306\' - retry-time: 60 retries: 1, Error_code: 2003
141010 0:03:48 [ERROR] Slave I/O: error connecting to master \'my@172.17.210.199:3306\' - retry-time: 60 retries: 2, Error_code: 2003
141010 0:04:48 [ERROR] Slave I/O: error connecting to master \'my@172.17.210.199:3306\' - retry-time: 60 retries: 3, Error_code: 2003
141010 0:05:48 [ERROR] Slave I/O: error connecting to master \'my@172.17.210.199:3306\' - retry-time: 60 retries: 4, Error_code: 2003
141010 0:06:48 [ERROR] Slave I/O: error connecting to master \'my@172.17.210.199:3306\' - retry-time: 60 retries: 5, Error_code: 2003
141010 0:07:48 [ERROR] Slave I/O: error connecting to master \'my@172.1