昨天对于Ubuntu的Mysql 进行配置,发现配置的时候,频繁出现问题。
log-bin的开启
这里的log-bin就是Mysql 的配置文件中的配置字段名:log-bin
在[Mysqld]添加
log-bin = mysql-bin
binlog_format = row
max_binlog_size = 200M
保存重启,发现重启不成功:
sudo systemctl status mysql.service
错误提示:
use --explicit_defaults_for_timestamp server option (see documentation for more details).
as process 3838 ...
mandatory server-id. Please refer to the proper server start-up parameters documentation
提示,配置log-bin的时候,要开启server-id 选项
参考文档: