MySQL主从报错(Last_SQL_Error: Slave failed to initialize relay log info structure from the repository)
Posted on 2022-08-24 15:01 高&玉 阅读(509) 评论(0) 编辑 收藏 举报背景
MySQL 8.0.29
CentOS 7.6
MySQL 8.0.29配置主从,在启动slave时报错:
Last_SQL_Errno: 13124
Last_SQL_Error: Slave failed to initialize relay log info structure from the repository
解决办法
在此之前此MySQL环境部署过MySQL Replication,存在旧的relay log。
重置slave,然后重新启动MySQL Slave即可
mysql> reset slave;
mysql> start slave;