docker start 报错
来源:3-3 Ubuntu中通过Docker安装配置MySQL主从节点

Zoom0
2019-04-09
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
log_bin = log #开启二进制日志,用于主从节点的历史复制回放
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8’
character-set-server = utf8
server_id = 1 #需保证主库和从库的server_id不同
replicate-do-db=fileserver #需要复制的数据库名
容器创建成功之后 docker start id。。docker ps 无任何容器 ,查看日志 docker logs id
ERROR: mysqld failed while attempting to check config
command was: “mysqld --verbose --help”
2019-04-09T07:05:02.646960Z 0 [ERROR] You have enabled the binary log, but you haven’t provided the mandatory server-id. Please refer to the proper server start-up parameters documentation
2019-04-09T07:05:02.649501Z 0 [ERROR] Aborting
ERROR: mysqld failed while attempting to check config
command was: “mysqld --verbose --help”
2019-04-09T07:05:17.823489Z 0 [ERROR] You have enabled the binary log, but you haven’t provided the mandatory server-id. Please refer to the proper server start-up parameters documentation
2019-04-09T07:05:17.829469Z 0 [ERROR] Aborting
大概意思是 您已启用二进制日志,但尚未提供必需的server-id。
完全按照文档来的啊
2回答
-
同学你好,看看是不是配置文件里中文符号的问题?
init-connect='SET NAMES utf8’
见到这行的后面那个单引号看起来不对.
052019-04-09 -
xiaomo
2019-04-09
试试把master和slave的两个配置文件精简化,去掉中文注释和多余空格,像这样:
master.conf
[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] log_bin=log collation-server=utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server=utf8 server_id=1 replicate-do-db=fileserver
slave.conf
[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] log_bin=log collation-server=utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server=utf8 server_id=2 replicate-do-db=fileserver
然后把已有的容器删掉重新运行下看看.这两个配置文件我在本地刚试了是可以的.
00
相似问题
回答 1
回答 1