Shulou(Shulou.com)06/01 Report--

# # I also made this mistake. Read other people's articles to solve it.

Link to the original article: http://blog.csdn.net/lwei_998/article/details/41210945

Add a slave to a host and report when it starts.

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

Reason: check my.cnf, originally did not specify relay_log,mysql default generated relay_log name is occupied by another mysql slave on this server.

Solution:

1. Add in my.cnf

Relay_log=/db/mysql56/logs/relay_98_3326

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

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.