python - 问 : can't install MySQL-Python on Mac OS10. 12.3

Question

当它出现时，我试图导入 MySQLdb:

>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named MySQLdb

所以我开始这样做安装MySQLdb:

pip install MySQL-Python

但是，我得到了错误信息:

Collecting MySQL-Python
  Using cached MySQL-python-1.2.5.zip
Installing collected packages: MySQL-Python
  Running setup.py install for MySQL-Python ... error
    Complete output from command /usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/var/folders/y4/qxwc6ps56fv6bc94vyp3ccjr0000gn/T/pip-build-ejJODG/MySQL-Python/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /var/folders/y4/qxwc6ps56fv6bc94vyp3ccjr0000gn/T/pip-pLamdE-record/install-record.txt --single-version-externally-managed --compile:

和

cc -bundle -undefined dynamic_lookup -arch x86_64 -arch i386 -Wl,-F. -Qunused-arguments -Qunused-arguments build/temp.macosx-10.12-intel-2.7/_mysql.o -L/usr/local/Cellar/mysql/5.6.27/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.12-intel-2.7/_mysql.so
    ld: library not found for -lssl
    clang: error: linker command failed with exit code 1 (use -v to see invocation)
    error: command 'cc' failed with exit status 1

然后，我尝试了这个:

export LIBRARY_PATH="$LIBRARY_PATH:/usr/local/lib"

但这没有任何意义。然后我尝试了另一种方法:

sudo pip install mysql-connector-python

但是，它也不起作用:

Collecting mysql-connector-python
  Could not find a version that satisfies the requirement mysql-connector-python (from versions: )
No matching distribution found for mysql-connector-python

由于我是 mac 和 python 的新手，所以我不知道发生了什么以及如何修复它。我的电脑上安装了python2.7.10。

Answer 1

使用PyMySQL反而。它是一个纯 Python 库，是 MySQL-Python 的替代品，并且运行良好。 MySQL-Python 的库依赖关系在各种平台上可能会带来麻烦。在您的情况下，它无法找到要链接的 open-ssl header 。

pip install pymysql