エラー内容 

$ pip3 install mysqlclient
Collecting mysqlclient
  Using cached https://files.pythonhosted.org/packages/f7/a2/1230ebbb4b91f42ad6b646e59eb8855559817ad5505d81c1ca2b5a216040/mysqlclient-1.3.14.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/cr/_q3pd9yj3ns8nhg022vknlhh0000gn/T/pip-install-77v1ykl5/mysqlclient/setup.py", line 16, in <module>
        metadata, options = get_config()
      File "/private/var/folders/cr/_q3pd9yj3ns8nhg022vknlhh0000gn/T/pip-install-77v1ykl5/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/cr/_q3pd9yj3ns8nhg022vknlhh0000gn/T/pip-install-77v1ykl5/mysqlclient/setup_posix.py", line 60, in <listcomp>
        libraries = [dequote(i[2:]) for i in libs if i.startswith('-l')]
      File "/private/var/folders/cr/_q3pd9yj3ns8nhg022vknlhh0000gn/T/pip-install-77v1ykl5/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 ?

    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/cr/_q3pd9yj3ns8nhg022vknlhh0000gn/T/pip-install-77v1ykl5/mysqlclient/

 

発生条件/原因/対処法

Macでmysqlclientインストール時に発生するエラー。

mysql-connector-c もしくは libmysqlclient の既存バグが原因。

mysql_configファイルの修正で解決する。

(mysql-connector-c の場合は /usr/local/Cellar/mysql-connector-c/6.1.11/bin にある)

以下のように修正。

 

■修正前

# Create options
libs="-L$pkglibdir"
libs="$libs -l "```

 

■修正後

# Create options
libs="-L$pkglibdir"
libs="$libs -lmysqlclient -lssl -lcrypto"