mysql show varialbe_AirFlow初始化的时候遇到 Global variable explicit_defaults_for_timestamp needs to be on (...

Traceback (most recent call last):

File"/opt/anaconda3/bin/airflow", line 32, in args.func(args)

File"/opt/anaconda3/lib/python3.7/site-packages/airflow/bin/cli.py", line 1102, ininitdb

db.initdb(settings.RBAC)

File"/opt/anaconda3/lib/python3.7/site-packages/airflow/utils/db.py", line 106, ininitdb

upgradedb()

File"/opt/anaconda3/lib/python3.7/site-packages/airflow/utils/db.py", line 377, inupgradedb

command.upgrade(config,'heads')

File"/opt/anaconda3/lib/python3.7/site-packages/alembic/command.py", line 298, inupgrade

script.run_env()

File"/opt/anaconda3/lib/python3.7/site-packages/alembic/script/base.py", line 489, inrun_env

util.load_python_file(self.dir,"env.py")

File"/opt/anaconda3/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 98, inload_python_file

module=load_module_py(module_id, path)

File"/opt/anaconda3/lib/python3.7/site-packages/alembic/util/compat.py", line 173, inload_module_py

spec.loader.exec_module(module)

File"", line 728, inexec_module

File"", line 219, in_call_with_frames_removed

File"/opt/anaconda3/lib/python3.7/site-packages/airflow/migrations/env.py", line 92, in run_migrations_online()

File"/opt/anaconda3/lib/python3.7/site-packages/airflow/migrations/env.py", line 86, inrun_migrations_online

context.run_migrations()

File"", line 8, inrun_migrations

File"/opt/anaconda3/lib/python3.7/site-packages/alembic/runtime/environment.py", line 846, inrun_migrations

self.get_context().run_migrations(**kw)

File"/opt/anaconda3/lib/python3.7/site-packages/alembic/runtime/migration.py", line 518, inrun_migrations

step.migration_fn(**kw)

File"/opt/anaconda3/lib/python3.7/site-packages/airflow/migrations/versions/0e2a74e0fc9f_add_time_zone_awareness.py", line 45, inupgrade"Global variable explicit_defaults_for_timestamp needs to be on (1) for mysql"Exception: Global variable explicit_defaults_for_timestamp needs to be on (1) for mysql