Slave is not configured or failed to initialize properly. You must at least set --server-id

最新推荐文章于 2022-02-14 20:13:12 发布
最新推荐文章于 2022-02-14 20:13:12 发布
阅读量1k 收藏
点赞数
分类专栏： mysql 主从同步 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/scgwz/article/details/106708288
版权

报错环境：新加从库，版本一样
在这里插入图片描述
网查资料都是drop 备份的 ibd表，另一种简单情况也会这个错误，就是server-id未设置或重复

1.编辑/etc/my.cnf

2.检查，没有则添加以下两行，有则修改重复id

log-bin=mysql-bin
server-id=3

3.重启mysql

/etc/init.d/mysqld restart

或者

service mysqld restart
scgwz
关注
专栏目录
Debezium从入门到精通系列之：百篇系列文章汇总之研究Debezium技术遇到的各种错误的解决方法
zhengzaifeidelushang的博客
07-30 2050
Debezium从入门到精通系列之：打通Debezium技术过程中遇到各种错误的解决方法之百篇系列文章汇总
mysql 5.5 主从同步数据到 msyql5.6数据库，报错为Slave is not configured or failed to initialize properly. You must
ahzxj2012的专栏
03-01 2006
报错为： Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in t 1、分析得之：
【MySQL change master 报错】 Slave is not configured or failed to initialize properly
授人以鱼不如授之以渔
02-14 2403
问题背景 今天数据库主库异常重启，导致数据丢失，所以在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
mysql Slave is not configured or failed to initialize properly. You must at least set --server-id
Gblfy_Blog
07-10 1226
文章目录1. 问题背景2. 解决方案 1. 问题背景 在创建mysql从节点复制链路时，由于虚拟机我是从一个模板复制而来的因此，server-id是一样的。 2. 解决方案 # 编辑/etc/my.cnf vi /etc/my.cnf # 添加如下2行代码 # 此处的server-id，只要不一样即可，我的mysql主节点是1，这里我设置为2 log-bin=mysql-bin server-id=2 #重启mysql systemctl restart mysql ...
ERROR 1794 (HY000) at line 22: Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log. 数据库导入时报错
05-24
你需要在从服务器上至少设置 `--server-id` 参数来启用一个主服务器或从服务器。此外，你可以查看 MySQL 的错误日志以获取更多的错误信息。 下面是一些可能有用的步骤： 1. 确保你已经正确地配置了主服务器和从...
mysql 1794_MySQL 跨版本主从复制时报错：ERROR 1794 (HY000): Slave is not configured or failed to initialize prop...
weixin_42514930的博客
01-27 575
背景： zabbix 数据库迁移，搭建主从，主是5.6.25，从是5.7.15，流式备份应用 redo.log 之后，change master 和reset slave 时报出如下错误mysql> CHANGE MASTER TO-> MASTER_HOST='192.168.40.129',-> MASTER_USER='repl',-> MASTER_PA...
[ERROR] [MY-011013] [Server] Failed to initialize D
最新发布
08-11
- *2* [mysql Slave is not configured or failed to initialize properly. You must at least set --server-id](https://blog.csdn.net/weixin_40816738/article/details/118640643)[target="_blank" data-report-...
MySQL 跨版本主从复制时报错：ERROR 1794 (HY000): Slave is not configured or failed to initialize properly....
weixin_30663391的博客
07-11 719
背景： zabbix 数据库迁移，搭建主从，主是5.6.25，从是5.7.15，流式备份应用 redo.log 之后，change master 和reset slave 时报出如下错误 mysql> CHANGE MASTER TO -> MASTER_HOST='192.168.40.129', -> MASTER_US...
MySQL复制ERROR 1794 (HY000): Slave is not configured or failed to initialize properly.
aecuhty88306453的博客
01-12 2064
ERROR 1794 (HY000): Slaveisnot configured or failed to initialize properly. You must at leastset--server-id to enable either a master or a slave. Additional error messages can be foundinthe...
主从复制时报：ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at lea...
weixin_30706507的博客
09-19 487
centos 6.5 mysql5.7 在从库作stop slave时报： error: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. Add...
mysql 1794错误_MySQL复制ERROR 1794 (HY000): Slave is not configured or failed to initialize properly....
weixin_39976153的博客
01-19 370
ERROR 1794 (HY000): Slaveisnot configured or failed to initialize properly. You must at leastset--server-id to enable either a master or a slave. Additional error messages can be foundinthe MySQL e...
ERROR 1794 (HY000): Slave is not configured or fai
weixin_34323858的博客
08-10 1433
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. Additio...
Slave is not configured or failed to initialize properly. You must at least set --server-id to enabl
net@core的博客
03-09 3512
背景： zabbix 数据库迁移，搭建主从，主是5.6.25，从是5.7.15，流式备份应用 redo.log 之后，change master 和reset slave 时报出如下错误 HANGE MASTER TO -> MASTER_HOST=‘192.168.40.129’, -> MASTER_USER=‘repl’, -> MASTER_...
mysql slave重建_MySQL复制ERROR 1794 (HY000): Slave is not configured or failed to initialize properly....
weixin_29594291的博客
02-17 341
ERROR 1794 (HY000): Slaveisnot configured or failed to initialize properly. You must at leastset--server-id to enable either a master or a slave. Additional error messages can be foundinthe MySQL e...
mysql error 1794_主从复制时报：ERROR 1794 (HY000): Slave is not configured or failed to initialize properly...
weixin_34493871的博客
01-27 1363
centos 6.5mysql5.7在从库作stop slave时报：error: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. Additiona...
mysql 1794_MySQL复制ERROR 1794 (HY000): Slave is not configured or failed to initialize properly.
weixin_28764823的博客
01-19 760
ERROR 1794 (HY000): Slaveisnot configured or failed to initialize properly. You must at leastset--server-id to enable either a master or a slave. Additional error messages can be foundinthe MySQL e...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值