Centos7使用pip安装mysqlclient时报错Exception: Can not find valid pkg-config name.

Defaulting to user installation because normal site-packages is not writeable
Collecting mysqlclient
  Using cached mysqlclient-2.2.0.tar.gz (89 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... error
  error: subprocess-exited-with-error

  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
  ╰─> [25 lines of output]
      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
      Trying pkg-config --exists mariadb
      Command 'pkg-config --exists mariadb' returned non-zero exit status 1.
      Traceback (most recent call last):
        File "/usr/lib/python3/dist-packages/pip/_vendor/pep517/in_process/_in_process.py", line 363, in <module>
          main()
        File "/usr/lib/python3/dist-packages/pip/_vendor/pep517/in_process/_in_process.py", line 345, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
        File "/usr/lib/python3/dist-packages/pip/_vendor/pep517/in_process/_in_process.py", line 130, in get_requires_for_build_wheel
          return hook(config_settings)
        File "/usr/lib/python3/dist-packages/setuptools/build_meta.py", line 162, in get_requires_for_build_wheel
          return self._get_build_requires(
        File "/usr/lib/python3/dist-packages/setuptools/build_meta.py", line 143, in _get_build_requires
          self.run_setup()
        File "/usr/lib/python3/dist-packages/setuptools/build_meta.py", line 158, in run_setup
          exec(compile(code, __file__, 'exec'), locals())
        File "setup.py", line 154, in <module>
          ext_options = get_config_posix(get_options())
        File "setup.py", line 48, in get_config_posix
          pkg_name = find_package_name()
        File "setup.py", line 27, in find_package_name
          raise Exception(
      Exception: Can not find valid pkg-config name.
      Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error

× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.

这个错误是在使用pip安装mysqlclient时报错，意思是无法通过pkg-config找到MySQL的相关库，可能因没有设置mysql的环境变量MYSQLCLIENT_CFLAGS和 MYSQLCLIENT_LDFLAGS。所以需要手动指定MySQL的头文件和库路径:

推荐查看此教程来安装MySQL数据库

CentOS7配置python和django项目开发环境(MySQL8.0+python3.9)-CSDN博客文章浏览阅读1.2k次，点赞39次，收藏24次。先更新一下系统。https://blog.csdn.net/qq_51261687/article/details/135232656?csdn_share_tail=%7B%22type%22%3A%22blog%22%2C%22rType%22%3A%22article%22%2C%22rId%22%3A%22135232656%22%2C%22source%22%3A%22qq_51261687%22%7D前提需要已经安装了mysql数据库

1. 1. 进入root模式，安装MySQL开发包

yum install mysql-devel

1. 2. 设置环境变量

• 编辑/etc/profile文件

vi /etc/profile

在文末补充添加以下行：

export MYSQLCLIENT_CFLAGS="-I/usr/include/mysql"
export MYSQLCLIENT_LDFLAGS="-L/usr/lib64/mysql"

• 保存并关闭文件。
• 重新加载/etc/profile文件，使更改生效：

source /etc/profile

1. 3. 重新安装mysqlclient

pip install mysqlclient