MySQL master-slave: Slave status display connecting state resolution

Error message Slave_io_running:connecting

Mysql> Show Slave Status\g

Slave_IO_Running: ConnectingSlave_SQL_Running: Yes

Here is generally two Yes is correct, appears slave_io_running:connecting is from the configuration may have a problem.

There are 3 main reasons that lead to lave_io_running as connecting:

1. Network does not pass
2. Wrong password
3. POS Not

To exclude two problems first and third,

• Network reason: There is no error when copying the backup files on the main library from the library, so you can exclude them.
• POS is not correct: this can also be excluded, because the POS content is copied over the main library, so this reason is also excluded.

  Remaining Password problem analysis:
  After checking, it is true that the password was incorrectly written when change master.

Steps to resolve:

1. Stop slave;
2. Re-chage parameters from
3. Start slave;
4. Show Slave Status\g
   Slave_io_running:yes
   Slave_sql_running:yes
5. Done, Resolved

MySQL master-slave: Slave status display connecting state resolution