linux下安装mysql-python笔记

62 阅读 0 评论 41 点赞

我是靠谱客的博主专注红酒，最近开发中收集的这篇文章主要介绍linux下安装mysql-python笔记，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

备忘安装过程遇到问题：

1. 安装setuptools

不安装的话，后面安装mysql-python时会报错。

官网下载、解压、安装。

下载地址：http://pypi.python.org/pypi/setuptools/

安装命令：

ln -s
/usr/local/python25/bin/python2.4 python2.4
PATH=.:$PATH
sh setuptools-0.6c11-py2.4.egg
rm python2.4

2、下载mysql-python

官网地址：http://sourceforge.net/projects/mysql-python/

# cd /usr/local

# wget http://nchc.dl.sourceforge.net/sourceforge/mysql-python/MySQL-python-1.2.2.tar.gz

2、解压

# tar -zxvf MySQL-python-1.2.2.tar.gz

# cd MySQL-python-1.2.2

3、在安装前要做下面几步

a、修改setup_posix.py中的mysql_config.path为你mysql安装目录的mysql_config路径（没有修改，修改出错）

b、修改site.cfg中的threadsafe = False，mysql_config = /usr/local/mysql/bin/mysql_config

c、执行命令：（没有修改）

# export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql

# ln -s /usr/local/mysql/lib/mysql/libmysqlclient.so /usr/lib/libmysqlclient.so.14

# ldconfig (这个重要)

否则后面会报错ImportError: libmysqlclient.so.14: cannot open shared object file

4、build和install

# python setup.py build

# python setup.py install

5、使用

# python

# >>> import MySSQLdb

如果报错

/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

原因是，install后MySQLdb模块已经被放到python的site-pachages目录中；但我在当前目录也存在相同的模块，所以可能会重复导入。只要切换到其他目录运行python就可以了。

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

参考http://blog.csdn.net/slvher/article/details/7865722

http://hi.baidu.com/seaweaver/item/1db27a152cefb125f7625cf6