MacOs 安装mysqlclient报错-解决方法

报错信息

Using cached https://pypi.tuna.tsinghua.edu.cn/packages/de/79/d02be3cb942afda6c99ca207858847572e38146eb73a7c4bfe3bdf154626/mysqlclient-2.1.0.tar.gz (87 kB)
  Preparing metadata (setup.py) ... error
  error: subprocess-exited-with-error

  × python setup.py egg_info did not run successfully.
  │ exit code: 1
  ╰─> [16 lines of output]
      /bin/sh: mysql_config: command not found
      /bin/sh: mariadb_config: command not found
      /bin/sh: mysql_config: command not found
      Traceback (most recent call last):
        File "<string>", line 2, in <module>
        File "<pip-setuptools-caller>", line 34, in <module>
        File "/private/var/folders/r9/zck2_0c90rl1r0jyd9_n19cw0000gn/T/pip-install-oc9_ygao/mysqlclient_101e45eac4fc4811b11bf68486dfacfe/setup.py", line 15, in <module>
          metadata, options = get_config()
        File "/private/var/folders/r9/zck2_0c90rl1r0jyd9_n19cw0000gn/T/pip-install-oc9_ygao/mysqlclient_101e45eac4fc4811b11bf68486dfacfe/setup_posix.py", line 70, in get_config
          libs = mysql_config("libs")
        File "/private/var/folders/r9/zck2_0c90rl1r0jyd9_n19cw0000gn/T/pip-install-oc9_ygao/mysqlclient_101e45eac4fc4811b11bf68486dfacfe/setup_posix.py", line 31, in mysql_config
          raise OSError("{} not found".format(_mysql_config_path))
      OSError: mysql_config not found
      mysql_config --version
      mariadb_config --version
      mysql_config --libs
      [end of output]

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

× Encountered error while generating package metadata.
╰─> See above for output.

原因分析：

安装mysqlclient依赖mysql-client，所以安装mysqlclient前需要安装mysql

操作步骤

1.安装mysql-client

$ brew install mysql-client

2.配置路径

$ echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile
$ export PATH="/usr/local/opt/mysql-client/bin:$PATH"

3.再次安装 

$ pip install mysqlclient

 

安装成功，最新版本为2.2.1