Python mac安装mysqlclient的一个bug

 

这是一个来自mysql官方的bug，反正我是看不懂。

shuais-MBP:wxapp dandyzhang$ pipenv install mysqlclient
Installing mysqlclient...
Collecting mysqlclient
  Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f7344d1cb31f128e6dbba70c5975c9e57896815dbb1988ad/mysqlclient-1.3.13.tar.gz
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/private/var/folders/rw/kmt8v6lj2fb37k0kh1ggm4m40000gn/T/pip-install-rwvfazf6/mysqlclient/setup.py", line 18, in <module>
        metadata, options = get_config()
      File "/private/var/folders/rw/kmt8v6lj2fb37k0kh1ggm4m40000gn/T/pip-install-rwvfazf6/mysqlclient/setup_posix.py", line 60, in get_config
        libraries = [dequote(i[2:]) for i in libs if i.startswith('-l')]
      File "/private/var/folders/rw/kmt8v6lj2fb37k0kh1ggm4m40000gn/T/pip-install-rwvfazf6/mysqlclient/setup_posix.py", line 60, in <listcomp>
        libraries = [dequote(i[2:]) for i in libs if i.startswith('-l')]
      File "/private/var/folders/rw/kmt8v6lj2fb37k0kh1ggm4m40000gn/T/pip-install-rwvfazf6/mysqlclient/setup_posix.py", line 13, in dequote
        raise Exception("Wrong MySQL configuration: maybe https://bugs.mysql.com/bug.php?id=86971 ?")
    Exception: Wrong MySQL configuration: maybe https://bugs.mysql.com/bug.php?id=86971 ?
    
    ----------------------------------------

Error:  An error occurred while installing mysqlclient!
Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/rw/kmt8v6lj2fb37k0kh1ggm4m40000gn/T/pip-install-rwvfazf6/mysqlclient/

This is likely caused by a bug in mysqlclient. Report this to its maintainers.

mysqlclient的作者在源码里已经写了个exception是专门针对这个报错的，就是上面加粗的那一句黑色的链接

Wrong MySQL configuration: maybe https://bugs.mysql.com/bug.php?id=86971 ?

它说，错误的mysql配置，可能是链接里的问题。

这里就不打开链接了解释了，反正就是一个官方的bug，里面也写了怎么解决。

 

 

首先安装mysql-connector

brew install mysql-connector-c

然后修改一下mysql_config文件，当然基于安全性的考虑需要先备份一下文件

cp /usr/local/bin/mysql_config /usr/local/bin/mysql_config.backup 

然后修改文件

sudo vim /usr/local/bin/mysql_config 

找到对应的内容位置

# Create options 
libs="-L$pkglibdir"
libs="$libs -l "
修改成
# Create options 
libs="-L$pkglibdir"
libs="$libs -lmysqlclient -lssl -lcrypto"

这时候安装mysqlclient就没问题了。。