mysql主从同步io_MySQL主从同步出现Slave_IO_Running:NO的解决办法

Master Slave 主从同步错误

Slave_IO_Running:NO

Slave_SQL_Running:Yes

#在Slave库上查看状态

mysql> show slave status\G

Slave_IO_Running: No

Slave_SQL_Running: Yes

#重启master库：service mysqld restart

mysql> show master status;

±-----------------±---------±-------------±-----------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |

±-----------------------±-------------±-------------±-----------------+

| mysql-bin.000534 | 14670663 | | |

±-----------------------±-------------±-------------±-----------------+

mysql> stop slave;

mysql> change master to Master_Log_File=‘mysql-bin.000001’,Master_Log_Pos=98;

mysql> start slave;

mysql> show slave status\G

Slave_IO_Running: Yes

Slave_SQL_Running: Yes