MySQL验证主从同步报‘Could not find first log file name in binary log index file‘错误的解决办法

‘Could not find first log file name in binary log index file’ 解决办法

1、背景

在做mysql主从的时候，查看从库状态(show slave status\G)，一直提示如下报错
‘ Could not find first log file name in binary log index file’

2、错误截图

3、解决办法

1）先在主库执行：

mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)

mysql> show master status\G
*************************** 1. row ***************************
             File: mysql-bin.000005
         Position: 154
     Binlog_Do_DB:
 Bin