mac mysql mysqldb_mac os 上安装mysqldb，EnvironmentError: mysql

$ sudo python setup.py clean $ sudo python setup.py build $ sudo python setup.py install $ export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH $python import MySQLdb /Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-m

$ sudo python setup.py clean

$ sudo python setup.py build

$ sudo python setup.py install

$export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH

$python

>>> import MySQLdb

/Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.pyc, but /Users/***/Downloads/MySQL-python-1.2.3

is being added to sys.path

>>> conn=MySQLdb.connect(host="localhost",user="root",passwd="root",db="mysql")

>>> cursor =conn.cursor()

>>> sql ="select * from user"

>>> cursor.execute(sql)

7L

>>> row=cursor.fetchone()

>>> print row

('localhost', 'root', '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '')

能够读取mysql.user表的信息了，说明已经mysqldb已经安装成功。

或者修改bash_profile文件

PATH="/usr/local/mysql/bin:${PATH}"export PATH

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/export VERSIONER_PYTHON_PREFER_64_BIT=yesexport VERSIONER_PYTHON_PREFER_32_BIT=no

参考：http://stackoverflow.com/questions/1465846/install-mysqldb-on-snow-leopard/6537345#6537345

本文原创发布php中文网，转载请注明出处，感谢您的尊重！