Mac OS X 10.11下如何安裝MySQLdb?

安裝完後:

Python 2.7.6 (default, Jul 3 2015, 01:44:46)
[GCC 4.2.1 Compatible Apple LLVM 7.0.0 (clang-700.0.58)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
&>&>&> import MySQLdb
Traceback (most recent call last):
File "&", line 1, in &
File "/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.11-intel.egg/MySQLdb/__init__.py", line 19, in &
import _mysql
ImportError: dlopen(/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.11-intel.egg/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib
Referenced from: /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.11-intel.egg/_mysql.so
Reason: unsafe use of relative rpath libmysqlclient.18.dylib in /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.11-intel.egg/_mysql.so with restricted binary


源自: python - MySQL Improperly Configured Reason: unsafe use of relative path

sudo install_name_tool -change libmysqlclient.18.dylib
/usr/local/mysql/lib/libmysqlclient.18.dylib
/Library/Python/2.7/site-packages/_mysql.so


sudo
ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib
/usr/local/lib/libmysqlclient.18.dylib

原因：

The computer security settings prevent the shared library _mysql.so from using a relative reference to the library libmysqlclient.18.dylib. In the future, the shared library _mysql.so may be updated. Until then, you can force it to use an absolute reference via the install_name_toolutility. Assuming that libmysqlclient.18.dylib is in /usr/local/mysql/lib/, then run the command:

解決方法：

sudo install_name_tool -change libmysqlclient.18.dylib

/usr/local/mysql/lib/libmysqlclient.18.dylib

/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.9-intel.egg/_mysql.so

來自：http://errorlog.lofter.com/post/1cb97859_7d3be93