Python 安装MySQLdb模块问题总结centos6.6下安装MySQLdb时出现“error: command 'gcc' failed with exit status 1”
1. 问题描述
在MySQL-python-1.2.3源码包根目录下执行安装命令：
# python setup.py install
出现以下信息：
error: command ‘gcc’ failed with exit status 1
2. 解决方法
在安装MySQLdb前安装以下依赖库：
# yum install python-devel mysql-devel zlib-devel openssl-devel
安装完以上依赖库后， 再在MySQL-python-1.2.3源码包根目录下执行以下安装命令即可：
# python setup.py install
如下信息表示MySQLdb安装成功：
Installed /usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg
Processing dependencies for MySQL-python==1.2.3
Finished processing dependencies for MySQL-python==1.2.3
接着还要重新编译安装Python-2.7.9， 在Python-2.7.9源码包根目录下执行以下命令:
# ./configure && make && make install
3. 检测模块MySQLdb是否可正常使用
在终端执行以下命令：
# python
Python 2.7.9 (default, Feb 7 2015, 17:28:17)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-11)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>>
ImportError: libmysqlclient.so.18: cannot open shared object file: No such file or directory
问题：
>>> import MySQLdb
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "build/bdist.linux-x86_64/egg/MySQLdb/__init__.py", line 19, in <module>
File "build/bdist.linux-x86_64/egg/_mysql.py", line 7, in <module>
File "build/bdist.linux-x86_64/egg/_mysql.py", line 6, in __bootstrap__
ImportError: libmysqlclient.so.18: cannot open shared object file: No such file or directory
解决方法：
1.查看libmysqlclient.so.18的路径
# find / -name libmysqlclient.so.18
2.链接
# ln -s /mysql/base/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18
我这里是64位的，如果是32位的链接到/usr/lib
