centosOS7 pip 安装mysqlclient-2.2.0报错Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually

我的环境

• centos7
• python3.1.1
• requirements.txt 包含mysqlclient-2.2.0 依赖包

使用 pip install -r requirements.txt 报错如下：

8.417 Command ‘pkg-config --exists mysqlclient’ returned non-zero exit status 127.
8.417 Trying pkg-config --exists mariadb
8.417 Command ‘pkg-config --exists mariadb’ returned non-zero exit status 127.
8.417 Traceback (most recent call last):
8.417 File “/usr/local/lib/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py”, line 353, in
8.417 main()
8.417 File “/usr/local/lib/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py”, line 335, in main
8.417 json_out[‘return_val’] = hook(**hook_input[‘kwargs’])
8.417 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
8.417 File “/usr/local/lib/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py”, line 118, in get_requires_for_build_wheel
8.417 return hook(config_settings)
8.417 ^^^^^^^^^^^^^^^^^^^^^
8.417 File “/tmp/pip-build-env-rso5c9e9/overlay/lib/python3.11/site-packages/setuptools/build_meta.py”, line 355, in get_requires_for_build_wheel
8.417 return self._get_build_requires(config_settings, requirements=[‘wheel’])
8.417 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
8.417 File “/tmp/pip-build-env-rso5c9e9/overlay/lib/python3.11/site-packages/setuptools/build_meta.py”, line 325, in _get_build_requires
8.417 self.run_setup()
8.417 File “/tmp/pip-build-env-rso5c9e9/overlay/lib/python3.11/site-packages/setuptools/build_meta.py”, line 341, in run_setup
8.417 exec(code, locals())
8.417 File “”, line 154, in
8.417 File “”, line 48, in get_config_posix
8.417 File “”, line 27, in find_package_name
8.417 Exception: Can not find valid pkg-config name.
8.417 Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually

解决方法：

降低mysqlclient 版本，替换mysqlclient-2.0.2 为1：

apache-airflow-providers-mysql==5.4.0
mysqlclient==2.1.0

参考地址：https://forum.astronomer.io/t/failure-install-apache-airflow-providers-mysql/2733