Can't load plugin: sqlalchemy.dialects:mysql

Question

i try to install airflow to my computer, but when i run commanline start with airlow(ex: airflow db init, airflow scheduler), i get result:

Traceback (most recent call last):
  File "/home/linhnq/.local/bin/airflow", line 5, in 
    from airflow.__main__ import main
  File "/home/linhnq/.local/lib/python3.10/site-packages/airflow/__init__.py", line 46, in 
    settings.initialize()
  File "/home/linhnq/.local/lib/python3.10/site-packages/airflow/settings.py", line 567, in initialize
    configure_orm()
  File "/home/linhnq/.local/lib/python3.10/site-packages/airflow/settings.py", line 273, in configure_orm
    engine = create_engine(SQL_ALCHEMY_CONN, connect_args=connect_args, **engine_args)
  File "", line 2, in create_engine
  File "/home/linhnq/.local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 309, in warned
    return fn(*args, **kwargs)
  File "/home/linhnq/.local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 522, in create_engine
    entrypoint = u._get_entrypoint()
  File "/home/linhnq/.local/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 655, in _get_entrypoint
    cls = registry.load(name)
  File "/home/linhnq/.local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load
    raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mysql

i use Ubuntu 22.04.1 LTS and here is mysql version i installed:

+--------------------------+-------------------------+
| Variable_name            | Value                   |
+--------------------------+-------------------------+
| admin_tls_version        | TLSv1.2,TLSv1.3         |
| immediate_server_version | 999999                  |
| innodb_version           | 8.0.30                  |
| original_server_version  | 999999                  |
| protocol_version         | 10                      |
| replica_type_conversions |                         |
| slave_type_conversions   |                         |
| tls_version              | TLSv1.2,TLSv1.3         |
| version                  | 8.0.30-0ubuntu0.22.04.1 |
| version_comment          | (Ubuntu)                |
| version_compile_machine  | x86_64                  |
| version_compile_os       | Linux                   |
| version_compile_zlib     | 1.2.12                  |
+--------------------------+-------------------------+
 and airflow.cnf i get setup like this: (i created user airflow:password)

 - executor = LocalExecutor
 - sql_alchemy_conn = mysql://airflow:password@localhost/airflowdb 
 - broker_url = pyamqp://airflow:password@localhost:5672/myvhost 
 - result_backend = db+mysql://airflow:password@localhost:3306/airflowdb
 - flower_basic_auth = user1:password1

how can i fix it?
thanks

Can't load plugin: sqlalchemy.dialects:mysql

0 Answers