mysql報錯1872: Slave failed to initialize relay log info structure from the repository

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

在一台主機上增加一個slave，啟動的時候報

[ERROR] Slave SQL: Slave failed to initialize relay log info structure from the repository, Error_code: 1872

原因：檢查my.cnf，原來沒指定relay_log，mysql預設産生的relay_log名被該server上的另一個mysql slave占用了。

1.在my.cnf中添加
relay_log=/db/mysql56/logs/relay_98_3326      

2. reset slave
mysql>reset slave
mysql>change master to
master_host='192.168.0.38',
master_user='repl',
master_password='slave',
master_port=3306,
master_log_file='mysql-bin.001229',
master_log_pos=15970007;
mysql>start slave;