Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum that master is configured to log; the first event 'mysqlbin.000031' at 120, the last event read from 'D:\mysql-5.6.17-winx64\mysql-5.6.17-winx64\data\mysqlbin.000031' at 120, the last byte read from 'D:\mysql-5.6.17-winx64\mysql-5.6.17-winx64\data\mysqlbin.00003'
原因:这个错误一般出现在master5.6,slave在低版本的情况下。这是由于5.6使用了crc32做binlog的checksum
解决方法:在主机配置文件中增加如下:
【mysqld】
binlog-checksum = none
原因:这个错误一般出现在master5.6,slave在低版本的情况下。这是由于5.6使用了crc32做binlog的checksum
解决方法:在主机配置文件中增加如下:
【mysqld】
binlog-checksum = none
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30046312/viewspace-2144147/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30046312/viewspace-2144147/