python-mysqldb安装

【转】python-mysqldb安装

安装mysqldb的模块。
解压：
$tar xfz MySQL-python-1.2.0.tar.gz
$cp -r MySQL-python-1.2.0 /usr/local/mysqldb #这样纯粹是为了方便自己以后能找的到安装目录
$cd /usr/local/mysqldb
$python setup.py build #注意啦，这一步是一定要做的，不然就安装不成功。
会提示安装：mysql_config,
安装:libmysqlclient15-dev
sudo apt-get install libmysqlclient15-dev
注：linux下安装提前要装好。
mysql-devel
mysql-share
python-devel
$python setup.py install #正式安装
然后进入:
$python

>>import MySQLdb

当我在MySQLdb的源码路径build及install完，并导入模块时，发生警告：
>>> import MySQLdb
/usr/lib/python2.3/site-packages/MySQL_python-1.2.2-py2.3-linux-i686.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib/python2.3/site-packages/MySQL_python-1.2.2-py2.3-linux-i686.egg/_mysql.pyc, but /usr/local/src/MySQL-python-1.2.2 is being added to sys.path

可能出现问题：

>>> import MySQLdb
Traceback (most recent call last):
File "", line 1, in
File "/usr/lib/python2.5/site-packages/PIL/__init__.py", line 19, in

File "build/bdist.linux-x86_64/egg/_mysql.py", line 7, in
File "build/bdist.linux-x86_64/egg/_mysql.py", line 6, in __bootstrap__
ImportError: libmysqlclient_r.so.16: cannot open shared object file: No such file or directory
>>>

解决：

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

原因是python无法找到mysql目录下的libmysqlclient_r.so.16动态库,其实MySQLdb是调用mysql的c函数库.所以本机上首先得安装了mysql
然后: export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql:$LD_LIBRARY_PATH
----------------------------------------------------------------------------------------------------------------------------
原因是，install后MySQLdb模块已经被放到python的site-pachages目录中；但我在当前目录也存在相同的模块，所以可能会重复导入。只要切换到其他目录运行就可以了。
搞定

一切正常，好啦.
------------------------------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26690043/viewspace-735452/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26690043/viewspace-735452/