explicit_defaults_for_timestamp

最新推荐文章于 2022-08-29 08:53:58 发布

哒哒儿

最新推荐文章于 2022-08-29 08:53:58 发布

阅读量4.9k

点赞数 1

分类专栏：运维文章标签： explicit_defaults_for_timestam mysql airflow

本文链接：https://blog.csdn.net/qq_29719097/article/details/83577021

版权

airflow initdb :

出现异常：Exception: Global variable explicit_defaults_for_timestamp needs to be on (1) for mysql

解决方式：

https://airflow.readthedocs.io/en/stable/faq.html#how-to-fix-exception-global-variable-explicit-defaults-for-timestamp-needs-to-be-on-1

docker exec -it meu_mysql /bin/bash

cd /etc/mysql/


root@8ab0b9bd6a08:/etc/mysql/conf.d# cat mysql.cnf 
[mysql]
root@8ab0b9bd6a08:/etc/mysql/conf.d# echo '[mysqld]' >> mysql.cnf 
root@8ab0b9bd6a08:/etc/mysql/conf.d# echo 'explicit_defaults_for_timestamp = 1' >> mysql.cnf 
root@8ab0b9bd6a08:/etc/mysql/conf.d# cat mysql.cnf 
[mysql]
[mysqld]
explicit_defaults_for_timestamp = 1

无法在进入mysql 后启动explicit_defaults_for_timestam