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

mysql> start slave
-> ;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

mysql 启动从 失败

解决方法：

mysql>reset slave;

然后重新 指定主服务信息，重启启动从即可

从同步失败 之后，处理办法

到主上查看

mysql> show master status \G
*************************** 1. row ***************************
File: mysql-bin-master.000009
Position: 154
Binlog_Do_DB:
Binlog_Ignore_DB: mysql,information_schema,performance_schema
Executed_Gtid_Set:
1 row in set (0.00 sec)

然后从上执行

change master to master_host=’192.168.1.222′,master_user=’slave’,master_password=’123456′;
change master to master_host=’192.168.1.222′,master_port= 3306, master_bind=”, master_user=’slave’,master_password=’123456′;

change master to master_log_file=’mysql-bin-master.000009‘, master_log_pos=154;

start    slave;

mysql> show slave status \G

-********关注下面两行情况是否都是yes*********-

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

-*****************-