Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "MySQL error ERROR1872 (HY000): how to solve Slave failed to initialize", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "MySQL error ERROR1872 (HY000): how to solve Slave failed to initialize"!

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

MySQL 5.6Fix error copying from the library

Mysql > start slave

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

Reason for reporting an error:

From the relay log before the library already exists

Solution:

Using the RESET SLAVE statement, clear the master information and relay log information, delete all relay log files, and start creating a new relay log

Mysql > stop slave

Mysql > reset slave

At this point, I believe you have a deeper understanding of "MySQL error ERROR1872 (HY000): how to solve Slave failed to initialize". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.