1、下載mysql-python
官網地址：http://sourceforge.net/projects/mysql-python/
2、安裝mysql-python
複製代碼 代碼如下:
# tar -zxvf MySQL-python-1.2.3.tar.gz
# cd MySQL-python-1.2.3
# whereis mysql_config
mysql_config: /usr/bin/mysql_config /usr/share/man/man1/mysql_config.1.gz
# vi site.cfg
threadsafe = False
mysql_config = /usr/bin/mysql_config
# whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
# export LD_LIBRARY_PATH=/usr/include/mysql
# python setup.py build
# python setup.py install
注意:
1.編譯mysql-python需要mysql標頭檔。
2.安裝mysql-python需要setuptools工具。
3、測試
複製代碼 代碼如下:
# python
>>> import MySQLdb
>>>
如果沒有錯誤提示或者以下錯誤提示，那麼表示安裝成功。
錯誤提示:
複製代碼 代碼如下:
/usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.pyc, but /root/MySQL-python-1.2.3 is being added to sys.path
報錯原因:
執行python setup.py install，MySQLdb模組會被拷貝python的site-packages目錄。如果在執行python的目錄中存在相同的模組，就可能重複匯入模組。
解決辦法:
換個目錄執行python即可。
