MySQL報錯ERROR1872(HY000):Slave failed to initialize怎么解

本篇內容主要講解“報錯ERROR1872(HY000):Slave failed to initialize怎么解決”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強。下面就讓小編來(lái)帶大家學(xué)習“MySQL報錯ERROR1872(HY000):Slave failed to initialize怎么解決”吧!

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

MySQL 5.6修復從庫復制時(shí)報錯

mysql> start slave;

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

報錯原因：

從庫已經(jīng)存在之前的relay log

解決方法：

使用RESET SLAVE語(yǔ)句，清除master信息和relay日志的信息，刪除所有的relay日志文件，并開(kāi)始創(chuàng )建一個(gè)全新的中繼日志

mysql> stop slave;

mysql> reset slave;