现象:MySQL主从数据库同步时报错:
Last_IO_Error: 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 'mysql-bin.000011' at 120, the last event read from './mysql-bin.000011' at 120, the last byte read from './mysql-bin.000011' at 120.'
原因:数据库版本不一致导致。
解决:
解决办法1:
数据库换成一致版本。
解决办法2:
在master的my.cnf或my.ini中设置 |