Mac上Python无法使用MySQLdb模块怎么办？
操作系统：
Mac os，版本：10.12.5，64bit Mysql：版本 5.7.18 Homebrew
使用 brew 安装了 mysql （ Server version: 5.7.18 Homebrew ） ，然后下载了 MySQLdb，正确安装尅没有报错，安装成功后报错，报错如下：
MySQL_python-1.2.5-py2.7.egg-info lazybone$ python -c "import MySQLdb"
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/MySQLdb/__init__.py", line 19, in <module>
import _mysql
ImportError: dlopen(/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so, 2): Symbol not found: _mysql_affected_rows
Referenced from: /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so
Expected in: flat namespace
in /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so
尝试如下解决方案，均未果：
- 替换 MySQL_python-1.2.5，也无效；
- 重新安装 pip uninstall MySQL-python,brew uninstall mysql,brew install mysql --universal,pip install MySQL-python
- 增加环境变量配置，export DYLD_LIBRARY_PATH=/usr/local/Cellar/mysql/5.7.18_1/lib/，export DYLD_LIBRARY_PATH=.:$DYLD_LIBRARY_PATH
_mysql.so 相关信息：
MySQL_python-1.2.5-py2.7.egg-info lazybone$ file /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so
/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so: Mach-O universal binary with 2 architectures: [x86_64: Mach-O 64-bit bundle x86_64] [i386: Mach-O bundle i386]
/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so (for architecture x86_64): Mach-O 64-bit bundle x86_64
/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.12-intel.egg/_mysql.so (for architecture i386): Mach-O bundle i386
ps:同样机器配置，同事可以安装并使用！！！（ Mysql 5.7.18 Homebrew + MySQL_python-1.2.4b4 ）
Mac上Python无法使用MySQLdb模块怎么办？
在Mac上直接用MySQLdb确实容易踩坑，它依赖系统环境。最稳的方案是改用mysqlclient，这是MySQLdb的维护版本，兼容且支持新Python。直接用pip装：
pip install mysqlclient
如果安装报错，通常是缺MySQL开发头文件。用Homebrew装MySQL客户端就能解决：
brew install mysql-client
echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.zshrc
source ~/.zshrc
然后重试pip install mysqlclient。代码里直接import MySQLdb就行，接口完全一样：
import MySQLdb
db = MySQLdb.connect(
host="localhost",
user="your_user",
passwd="your_password",
db="your_db"
)
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
print(cursor.fetchone())
如果项目必须用原版MySQLdb，可以试试pip install mysqlclient==1.3.12指定旧版，但不如直接换mysqlclient省事。
总结：换mysqlclient一劳永逸。
mysql 这个驱动挺难装的，我当时遇到很多麻烦，而且第一次花了很长时间之后把系统的 python 搞坏了，只好重装系统（ osx ）
一定要在虚拟环境用这个东西……
而且安装的时候，貌似 mysql 服务是要开着的
另外我怀疑你这个 mysql 版本和 python-mysql 版本不对应，要注意 64 位还是 32 位，python-myql 版本支持不支持当前 python 版本和 mysql 版本
• You installed python
• You did brew install mysql
• You did export PATH=$PATH:/usr/local/mysql/bin
And finally, you did pip install MySQL-Python
via: https://stackoverflow.com/questions/25459386/mac-os-x-environmenterror-mysql-config-not-found/25491082#25491082
sudo install_name_tool -change libmysqlclient.18.dylib <br> /usr/local/mysql/lib/libmysqlclient.18.dylib <br> /Library/Python/2.7/site-packages/_mysql.so
