首頁 > 資料庫 > mysql教程 > mac os 上安装mysqldb,EnvironmentError: mysql

mac os 上安装mysqldb,EnvironmentError: mysql

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
發布: 2016-06-07 15:08:41
原創
1214 人瀏覽過

$ 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=<span>"</span><span>/usr/local/mysql/bin:${PATH}</span><span>"</span><span>
export PATH
export DYLD_LIBRARY_PATH</span>=/usr/local/mysql/lib/<span>
export VERSIONER_PYTHON_PREFER_64_BIT</span>=yes<span>
export VERSIONER_PYTHON_PREFER_32_BIT</span>=no
登入後複製

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

相關標籤:
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
最新問題
mac使用
來自於 1970-01-01 08:00:00
0
0
0
Mac怎麼安裝呢?
來自於 1970-01-01 08:00:00
0
0
0
Mac 怎麼沒有PHPstudy
來自於 1970-01-01 08:00:00
0
0
0
phpstudy何時出mac版的呀?
來自於 1970-01-01 08:00:00
0
0
0
希望能在mac出工具!
來自於 1970-01-01 08:00:00
0
0
0
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板