Mysql报错:Got fatal error 1236 from master when reading data from binary log: ‘Could not find first lo

报错:Got fatal error 1236 from master when reading data from binary log: ‘Could not find first lo"/>

Mysql报错:Got fatal error 1236 from master when reading data from binary log: ‘Could not find first lo

主从同步时,slave报错,错误信息:
Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file’

1. 登录主服务器执行

flush logs;

2.查看主节点binlog信息

show master status \G

3. 从服务器停止slave

stop slave;

4. 修改chang master

CHANGE MASTER TOMASTER_HOST='192.168.31.157',MASTER_USER='repluser',MASTER_PASSWORD='Pana#123',MASTER_PORT=3306,MASTER_LOG_FILE='mysql-bin.000014',MASTER_LOG_POS=156;

5. 启动slave

start slave;

6. 查看slave状态

show slave status \G

7.补充:

千万注意CHANGE MASTER TO语句中’'内的内容,很多时候复制会带空格,当出现空格时因为匹配不到文件或用户名密码等信息造成这个报错.
比较简单的方法是粘贴到记事本中,替换掉多余的空格.

8.其他可能

binlog名错误也会造成该报错.
用该命令确认binlog名.

show master status \G