mac mysql config_Mac 安装mysqlclient报错 OSError: mysql_config not found

在Mac上pip install mysqlclient时报错如下

Complete output from command python setup.py egg_info:

/bin/sh: mysql_config: command not found

Traceback (most recent call last):

File "", line 1, in

File "/private/var/folders/ww/hnzjh2z517d72m15ybyhwkbw0000gn/T/pip-build-mvq09hkr/mysqlclient/setup.py", line 17, in

metadata, options = get_config()

File "/private/var/folders/ww/hnzjh2z517d72m15ybyhwkbw0000gn/T/pip-build-mvq09hkr/mysqlclient/setup_posix.py", line 44, in get_config

libs = mysql_config("libs_r")

File "/private/var/folders/ww/hnzjh2z517d72m15ybyhwkbw0000gn/T/pip-build-mvq09hkr/mysqlclient/setup_posix.py", line 26, in mysql_config

raise EnvironmentError("%s not found" % (mysql_config.path,))

OSError: mysql_config not found

解决过程：

网上搜了不少方法都是如下

1、brew install mysql-connector-c

再次pip install mysqlclient 还是报错搜了好多都未解决，主要卡在没有找到

/usr/local/Cellar/mysql-connector-c/6.1.11/bin这个路径，后来发现我的路径是/usr/local/Cellar/mysql-client/8.0.19/bin，

下面有mysql_config这个文件，进入文件后发现第114行并不是截图这样，是已经修改好的，应该是mysqlclient最新版本已经优化过了。所以我的解决方法如下：

2、vim ~/.bash_profile 添加

export LDFLAGS="-L/usr/local/opt/openssl/lib"

export CPPFLAGS="-I/usr/local/opt/openssl/include"

export PATH="/usr/local/opt/mysql-client/bin:$PATH"

3、pip install mysqlclient 这次成功了