no comments yet
24 Jun 2015

ImportError: No module named MySQLdb解决办法

在CENTOS下测试python时出现错误,提示ImportError: No module named MySQLdb,以下是解决方法:

需要安装以下软件包:

setuptools-0.6c11.tar.gz
MySQL-python-1.2.3.tar.gz

1、安装setuptools-0.6c11

wget --no-check-certificate  https://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz
tar zxf setuptools-0.6c11.tar.gz && cd setuptools-0.6c11
python setup.py build
python setup.py install

2、安装MySQL-python-1.2.3

wget https://jaist.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz
tar zxf MySQL-python-1.2.3.tar.gz && cd MySQL-python-1.2.3
python setup.py build
python setup.py install

如果在执行python setup.py build时,报EnvironmentError: mysql_config not found的话,先查找mysql_config的位置,使用find / -name mysql_config查找,我的是在/usr/local/mysql/bin/mysql_config,然后修改MySQL-python-1.2.3目录下的site.cfg文件,去掉mysql_config=XXX这行的注释,并改成mysql_config=/usr/local/mysql/bin/mysql_config,以自己机器的为准。再执行下面命令就可以了。

python setup.py build
python setup.py install

附:ubuntu/debian系统
直接

sudo apt-get install python-mysqldb

如果编译
需要

sudo apt-get install libmysqlclient-dev