[MAC] Mac OS 升級後，遇到 MySQL_python import error

這問題，幾乎我只要升級MacOS就會遇到一次

 

Error Message

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

Reason: image not found

 

Troubleshooting steps:

1.找出你安裝的Mysql_python 版本

pip freeze local|grep MySQL

2.

find out what library paths the MySQLdb C extension _mysql.so is looking for

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

 

2. Install  or   Just copy missing libmysqlclient.xx.dylib to the lib folder

 otool -DX /opt/local/lib/mysql5/mysql/libmysqlclient_r.16.dylib