1. 首先确认python的版本为2.3.4以上,如果不是需要升级python的版本
python -V 检查python版本
2. yum -y install python-devel
3. 下载 MySQL-python-1.2.2.tar.gz
4. 安装 MySQl-python
- tar xvzf MySQL-python-1.2.2.tar.gz
- cd MySQL-python-1.2.2
- vi site.cfg
- 把 mysql_config = /usr/local/mysql/bin/mysql_config 这一行前的#去掉,并且把mysql_config的路径设置正确。
- python setup.py build
- sudo python setup.py install
安装结束
5. 测试
运行: python
import MySQLdb
如果没有报错,说明安装好了。
错误一:
- python2.6 setup.py install
- Traceback (most recent call last):
- File "setup.py", line 5, in <module>
- from setuptools import setup, Extension
- ImportError: No module named setuptools
处理方法,安装setuptools
- wget http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz
- tar zxvf setuptools-0.6c11.tar.gz
- cd setuptools-0.6c11
- python2.6 setup.py install
错误二:
import _mysql
ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory
处理方法有两种:
方法一. vi /etc/profile, 把/pathtomysql/lib/mysql加到LD_LIBRARY_PATH环境变量中
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib/mysql
注:MySQL5.5是:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib
方法二.将建链接到/usr/lib
- cd /usr/lib
- ln -s /path/to/mysql50/lib/mysql/libmysqlclient_r.so.15.0.0 libmysqlclient_r.so.15
- ln -s /path/to/mysql50/lib/mysql/libmysqlclient_r.so.15.0.0 libmysqlclient_r.so