MYSQL主从同步，Slave_IO_Running: No ！！懂的请进

Question

mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Connecting to master
                Master_Host: *.*.*.166
                Master_User: ekwlbak
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File:
        Read_Master_Log_Pos: 4
             Relay_Log_File: www-relay-bin.000006
              Relay_Log_Pos: 98
      Relay_Master_Log_File: www-relay-bin.000004
           Slave_IO_Running: No
          Slave_SQL_Running: Yes
            Replicate_Do_DB: hlxl,xwb
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 4
            Relay_Log_Space: 98
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: NULL
1 row in set (0.00 sec)

Answer 1

 在本机，登陆下你要同步的那台机器的数据库, 登陆的上去,Slave_IO_Running 就会变成yes.

Answer 2

Slave_IO_State: Connecting to master
  Master_Host: *.*.*.166
  Master_User: ekwlbak
  Master_Port: 3306你在SLAVE机器上，用ekwlbak这个账户，登录*.*.*.166，看能登录上去么？

Answer 3

[root@www /]#  mysql -h*.*.*.166 -ubakdai -pdaibayi5313
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.86-log Source distributionType 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

Answer 4

在主上看看这个而用户有没有复制得权限show grants for  ekwlbak@'*.*.*.166'

Answer 5

mysql> show grants for ekwlbak@'*.41.27.114'
    -> ;
+-------------------------------------------------------------------------------                            --------------------------------------------------------------------------------                            -+
| Grants for ekwlbak@*.41.27.114                                                                                                                                                                                          |
+-------------------------------------------------------------------------------                            --------------------------------------------------------------------------------                            -+
| GRANT RELOAD, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'ekwlbak'@'*                            *.41.27.114' IDENTIFIED BY PASSWORD '*2C4CA0E1766F8758A5CE61C1D0A5565F8210B9E1'                             |
| GRANT ALL PRIVILEGES ON `xwb`.* TO 'ekwlbak'@'*.41.27.114'                                                                                                                                                              |
| GRANT ALL PRIVILEGES ON `hlxl`.* TO 'ekwlbak'@'*.41.27.114'                                                                                                                                                             |
+-------------------------------------------------------------------------------                            --------------------------------------------------------------------------------                            -+
3 rows in set (0.00 sec)查了有给啊

Answer 6

在SLAVE机器上的mysql中启动io线程,然后看看启动没有start slave IO_THREAD;show slave status\G