环境
linux 7.0
python 2.7.5
问题
执行Python脚本,发生报错如下
ImportError: No module named MySQLdb
得知须安装【MySQL-python】模块
遂下载编译安装MySQL-python-1.2.5.zip,发生如下报错
EnvironmentError: mysql_config not found
而后,被各种依赖整疯,好容易装完MySQL-python-1.2.5.zip,取出已编译安装包,在新机器上测试,可离线安装。
解决
文件:/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg
1、查看现有系统是否有安装数据库,若已安装mysql,请从4开始执行
rpm -qa | grep mysql
mysql-community-server-5.7.20-1.el7.x86_64
mysql-community-libs-compat-5.7.20-1.el7.x86_64
mysql-community-libs-5.7.20-1.el7.x86_64
mysql-community-client-5.7.20-1.el7.x86_64
mysql-community-devel-5.7.20-1.el7.x86_64
mysql-community-common-5.7.20-1.el7.x86_64
2、若有mariadb-libs-5.5.56-2.el7.x86_64,使用rpm卸载
rpm -qa | grep mariadb
rpm -e mariadb-libs-1:5.5.56-2.el7.x86_64 --nodeps
3、安装Mysql
请按如下顺序安装,否则会报错
rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm
4、将文件放在该目录下【MySQL_python-1.2.5-py2.7-linux-x86_64.egg】
/usr/lib64/python2.7/site-packages/
5、执行该语句
echo MySQL_python-1.2.5-py2.7-linux-x86_64.egg > /usr/lib64/python2.7/site-packages/pythonmysql.pth