Centos6.7下安装python连接mysql环境故障解决，, 在Python连接

Centos6.7下安装python连接mysql环境故障解决，, 在Python连接

在Python连接和使用mysql时，需要调用MySQLdb 模块，是用于Python链接Mysql数据库的接口，它实现了 Python 数据库 API 规范 V2.0，基于 MySQL C API 上建立的。

MySQLdb模块在不同的平台下安装方式不一样，这里主要介绍Linux下的安装方式，https://pypi.python.org/pypi/MySQL-python 可以在这里选择合适的版本，解压安装。

安装步骤：

1、选择合适的版本以及检查相关路径这里选择版本为MySQL-python-1.2.5.zip，下面是下载路径与过程。wgethttps://pypi.python.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip--2016-10-0821:34:56--https://pypi.python.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zipResolvingpypi.python.org...151.101.76.223,2a04:4e42:12::223Connectingtopypi.python.org|151.101.76.223|:443...connected.HTTPrequestsent,awaitingresponse...200OKLength:108935(106K)[application/octet-stream]Savingto:“MySQL-python-1.2.5.zip”100%[======================================================>]108,935--.-K/sin0.1s2016-10-0821:34:57(1.00MB/s)-“MySQL-python-1.2.5.zip”saved[108935/108935][[email protected]python]#lsmysql.pyMySQL-python-1.2.5.zip解压：[[email protected]python]#unzipMySQL-python-1.2.5.zipArchive:MySQL-python-1.2.5.zipinflating:MySQL-python-1.2.5/GPL-2.0inflating:MySQL-python-1.2.5/HISTORYinflating:MySQL-python-1.2.5/INSTALLinflating:MySQL-python-1.2.5/MANIFEST.ininflating:MySQL-python-1.2.5/metadata.cfginflating:MySQL-python-1.2.5/PKG-INFOinflating:MySQL-python-1.2.5/pymemcompat.hinflating:MySQL-python-1.2.5/README.mdinflating:MySQL-python-1.2.5/setup.cfginflating:MySQL-python-1.2.5/setup.pyinflating:MySQL-python-1.2.5/setup_common.pyinflating:MySQL-python-1.2.5/切换到解压目录安装：使用命令pythonsetup.pybuild&&pythonsetup.pyinstall安装报错：[[email protected]MySQL-python-1.2.5]#pythonsetup.pybuildTraceback(mostrecentcalllast):File"setup.py",line7,in<module>importsetuptoolsImportError:Nomodulenamedsetuptools提示缺少setuptools可以在安装命令和上面一样，等最后执行完毕没有报错，安装成功，我们继续安装上面的。pythonsetup.pybuildrunningbuildrunningbuild_pycreatingbuildcreatingbuild/libcopyingpkg_resources.py->build/libcopyingeasy_install.py->build/libcopyingsite.py->build/libcreatingbuild/lib/setuptoolscopyingsetuptools/package_index.py->build/lib/setuptoolscopyingsetuptools/depends.py->build/lib/setuptoolscopyingsetuptools/extension.py->build/lib/setuptoolscopyingsetuptools/__init__.py->build/lib/set。。。。。。Installed/usr/local/python2.7.11/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.eggProcessingdependenciesforsetuptools==0.6c11Finishedprocessingdependenciesforsetuptools==0.6c11[[email protected]setuptools-0.6c11]#cd..继续安装MySQL-python出现error:command‘gcc‘failedwithexitstatus1可以用以下命令解决yuminstallgccpython-develmysql-devellibxml2libxml2-devlibxslt*zlibgccopenssl

安装完成后的检验：

在shell窗口调用Python命令，然后执行，不报错即可

importMySQLdb

Centos6.7下安装python连接mysql环境故障解决