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回答

xiaomo

2019-04-09

同学你好,看看是不是配置文件里中文符号的问题?

init-connect='SET NAMES utf8’

见到这行的后面那个单引号看起来不对.

0
5
Zoom0
非常感谢!
2019-04-09
共5条回复

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

然后把已有的容器删掉重新运行下看看.这两个配置文件我在本地刚试了是可以的.

0
0

Go实战仿百度云盘-实现企业级分布式云存储系统

紧随“云时代”技术潮流,分布式云存储系统,做第一代云程序员

1077 学习 · 494 问题

查看课程