一、 背景

python项目中需要操作mysql，于是运行：

pip install MySQL-python

报一连串的错误，前面的错误根据提示都好解决，但被下面的错误一直卡住，好一翻折腾才解决，所以在此记录以备忘。

Cannot open include file: ‘config-win.h’: No such file or directory” while installing mysql-python

二、 安装

1. 安装64位版本的python

https://www.python.org/ftp/python/2.7.14/python-2.7.14.amd64.msi

2. 安装VCForPython

去微软官网下载?
没有安装时会报如下错误：

根据错误提示，访问：http://aka.ms/vcpython27?C:UsersadminDesktop>pip install mysql-python Collecting mysql-python Using cached MySQL-python-1.2.5.zip Installing collected packages: mysql-python Running setup.py install for mysql-python ... error Complete output from command c:python27python.exe -u -c "import setuptools,tokenize;__file__=‘c:usersadminappdatalocaltemppip-build-srpbqqmysql-pythonsetup.py‘;f=getattr(tokenize,‘open‘,open)(__file__);code=f.read().replace(‘rn‘,‘n‘);f.close();exec(compile(code,__file__,‘exec‘))" install --record c:usersadminappdatalocaltemppip-6qgvvl-recordinstall-record.txt --single-version-externally-managed --compile: running install running build running build_py creating build creating buildlib.win-amd64-2.7 copying _mysql_exceptions.py -> buildlib.win-amd64-2.7 creating buildlib.win-amd64-2.7MySQLdb copying MySQLdb__init__.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbconverters.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbconnections.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbcursors.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbrelease.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbtimes.py -> buildlib.win-amd64-2.7MySQLdb creating buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstants__init__.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsCR.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsFIELD_TYPE.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsER.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsFLAG.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsREFRESH.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsCLIENT.py -> buildlib.win-amd64-2.7MySQLdbconstants running build_ext building ‘_mysql‘ extension error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27 ---------------------------------------- Command "c:python27python.exe -u -c "import setuptools,‘exec‘))" install --record c:usersadminappdatalocaltemppip-6qgvvl-recordinstall-record.txt --single-version-externally-managed --compile" failed with error code 1 in c:usersadminappdatalocaltemppip-build-srpbqqmysql-python C:UsersadminDesktop>

下载相应版本的VCForPython安装，再次安装mysql-python

3. 安装mysql-connector-python-2.1.7-py2.7-windows-x86-64bit.msi

https://cdn.mysql.com//Downloads/Connector-Python/mysql-connector-python-2.1.7-py2.7-windows-x86-64bit.msi

4. 安装mysql-connector-c-6.0.2-winx64.msi

https://cdn.mysql.com//Downloads/Connector-C/mysql-connector-c-6.0.2-winx64.msi?
没有安装【mysql-connector-python】与【mysql-connector-c-6.0.2】时，会报如下错误：

C:UsersadminDesktop>pip install mysql-python Collecting mysql-python Using cached MySQL-python-1.2.5.zip Installing collected packages: mysql-python Running setup.py install for mysql-python ... error Complete output from command c:python27python.exe -u -c "import setuptools,tokenize;__file__=‘c:usersadminappdatalocaltemppip-build-r8dkiwmysql-pythonsetup.py‘;f=getattr(tokenize,‘exec‘))" install --record c:usersadminappdatalocaltemppip-srrfzx-recordinstall-record.txt --single-version-externally-managed --compile: running install running build running build_py creating build creating buildlib.win-amd64-2.7 copying _mysql_exceptions.py -> buildlib.win-amd64-2.7 creating buildlib.win-amd64-2.7MySQLdb copying MySQLdb__init__.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbconverters.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbconnections.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbcursors.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbrelease.py -> buildlib.win-amd64-2.7MySQLdb copying MySQLdbtimes.py -> buildlib.win-amd64-2.7MySQLdb creating buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstants__init__.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsCR.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsFIELD_TYPE.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsER.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsFLAG.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsREFRESH.py -> buildlib.win-amd64-2.7MySQLdbconstants copying MySQLdbconstantsCLIENT.py -> buildlib.win-amd64-2.7MySQLdbconstants running build_ext building ‘_mysql‘ extension creating buildtemp.win-amd64-2.7 creating buildtemp.win-amd64-2.7Release C:UsersadminAppDataLocalProgramsCommonMicrosoftVisual C++ for Python9.0VCBinamd64cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -Dversion_info=(1,2,5,‘final‘,1) -D__version__=1.2.5 "-IC:Program Files (x86)MySQLMySQL Connector C 6.0.2include" -Ic:python27include -Ic:python27PC /Tc_mysql.c /Fobuildtemp.win-amd64-2.7Release_mysql.obj /Zl _mysql.c _mysql.c(42) : fatal error C1083: Cannot open include file: ‘config-win.h‘: No such file or directory error: command ‘C:UsersadminAppDataLocalProgramsCommonMicrosoftVisual C++ for Python9.0VCBinamd64cl.exe‘ failed with exit status 2 ---------------------------------------- Command "c:python27python.exe -u -c "import setuptools,‘exec‘))" install --record c:usersadminappdatalocaltemppip-srrfzx-recordinstall-record.txt --single-version-externally-managed --compile" failed with error code 1 in c:usersadminappdatalocaltemppip-build-r8dkiwmysql-python

5. MySQL-python-1.2.5.zip

https://pypi.python.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip#md5=654f75b302db6ed8dc5a898c625e030c?
注意：没有安装【mysql-connector-python】与【mysql-connector-c-6.0.2】时：此步骤会一直报错：?
> Cannot open include file: ‘config-win.h’: No such file or directory” while installing mysql-python

注意：即使已经安装了【mysql-connector-python】与【mysql-connector-c-6.0.2】，也可能会报上面的错误

原因： pypi上提供的MySQL-python包依赖32位的mysql-connector-c-6.0.2包，因为我们前面只安装了64位的版本，所有一直找不到mysql-connector-c-6.0.2而报上面的错误

• 解决方法一：?
  去mysql官网下载32位的mysql-connector-c-6.0.2，同时安装32位版本与64位版本，再运行：?【亲测，失败，但此方法应该可以，原因本人没有深究】

pip install mysql-python

• 1

?

• 解决方法二：?
  下载MySQL-python-1.2.5的源码，解压并修改文件【MySQL-python-1.2.5/site.cfg】，找到如下一行的路径，将其修改成如下第二行（修改引用版本，将32位指向64位），再运行python setup.py install安装【亲测通过】?(前提：安装64位的mysql-connector-c-6.0.2，)?

?

connector = C:Program Files (x86)MySQLMySQL Connector C 6.0.2?
connector = C:Program FilesMySQLMySQL Connector C 6.0.2

# 源码安装 cd MySQL-python-1.2.5 python setup.py install