从网上查了无数,发现都无法解决问题。经过无数次的挣扎与痛苦的尝试,我觉得应该回归第一性原理了。从mysql官网慢慢找么??NO,那也太费时间了,关键还难。于是,我开始了如下操作:
/etc/mysql/conf.d/
vim build.cnf
然后将要写入的内容粘贴
log-bin = mysql-bin
server-id = 2
binlog-do-db = blade_device_data,blade_device_data_other,blade_device_data_jc
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema
sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
其次,
esc : wq ! 退出保存
最后
docker-compose restart
ok!成功搞定,之前是我肤浅了,只知道什么mysqld.cnf,my.cnf,解决问题还是要不断向上推断,跳出误判性心理陷阱。