【MySQL change master 报错】 Slave is not configured or failed to initialize properly_渔不是鱼的博客-CSDN博客

网站介绍:问题背景今天数据库主库异常重启,导致数据丢失,所以在5.5版本(历史遗留问题)的MySQL主库上重新做了一份新的备份,还原到从库(从库是5.7的版本),还原非常成功,但是在搭建主从关系的时候,发生了如下报错:ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave