安装mysql-python时出现"_mysql Cannot open include file: 'config-win.h': No such file or directory"错误。

3

我试图安装两个名为mysql-python和mysqlclient(mysql-python的分支)的Python库,但是当我使用pip进行安装时,出现了以下错误:

Collecting mysql-python
  Using cached MySQL-python-1.2.5.zip
Installing collected packages: mysql-python
  Running setup.py install for mysql-python
    Complete output from command "c:\python 3.5\python.exe" -c "import setuptools, tokenize;__file__='C:\\Users\\ADMINI~1\\AppData\\Local\\Temp\\2\\pip-build-32um1ofe\\mysql-python\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record C:\Users\ADMINI~1\AppData\Local\Temp\2\pip-dm8bja_5-record\install-record.txt --single-version-externally-managed --compile:
    running install
    running build
    running build_py
    creating build
    creating build\lib.win32-3.5
    copying _mysql_exceptions.py -> build\lib.win32-3.5
    creating build\lib.win32-3.5\MySQLdb
    copying MySQLdb\__init__.py -> build\lib.win32-3.5\MySQLdb
    copying MySQLdb\converters.py -> build\lib.win32-3.5\MySQLdb
    copying MySQLdb\connections.py -> build\lib.win32-3.5\MySQLdb
    copying MySQLdb\cursors.py -> build\lib.win32-3.5\MySQLdb
    copying MySQLdb\release.py -> build\lib.win32-3.5\MySQLdb
    copying MySQLdb\times.py -> build\lib.win32-3.5\MySQLdb
    creating build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\__init__.py -> build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\CR.py -> build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\ER.py -> build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\REFRESH.py -> build\lib.win32-3.5\MySQLdb\constants
    copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.5\MySQLdb\constants
    running build_ext
    building '_mysql' extension
    creating build\temp.win32-3.5
    creating build\temp.win32-3.5\Release
    C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" "-Ic:\python 3.5\include" "-Ic:\python 3.5\include" "-IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" "-IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\ATLMFC\INCLUDE" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.10150.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" "-IC:\Program Files (x86)\Windows Kits\8.1\include\shared" "-IC:\Program Files (x86)\Windows Kits\8.1\include\um" "-IC:\Program Files (x86)\Windows Kits\8.1\include\winrt" /Tc_mysql.c /Fobuild\temp.win32-3.5\Release\_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:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\cl.exe' failed with exit status 2

    ----------------------------------------

我已经阅读了"Cannot open include file: 'config-win.h': No such file or directory" while installing mysql-python,但它并没有帮助到我。我的MySQL安装在C:/xampp/目录下,我正在使用Windows Server 2008 x64和Python 3.5 32位版本。注意:请不要投票否决,因为我无法从其他问题中得到帮助!


你正在尝试安装哪个版本的MySQL? - user5457708
1
请尝试从此处安装版本1.2.3:http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/ - user5457708
我现在无法测试,因为我正在使用Python 3.5。你知道我应该在mysqlclient中使用哪个版本吗? - Ali SH
无论如何,检查“MySQLdb安装”下面的链接,并找到最适合您的。 - user5457708
MySQL在VS2013上运行正常,可以阅读以下链接了解详情:http://dev.mysql.com/doc/relnotes/mysql-for-visual-studio/en/visual-studio-news-1-2-4.html - user5457708
显示剩余3条评论
2个回答

2
我知道这个问题很老,但解决方法是: 安装VS2010,然后再安装MySQL Connector for Python,就可以无问题地安装了! 编辑: 您可以使用官方的MySQL Connector for Python。它可以在这里轻松下载,适用于所有平台!

连接器对我来说不起作用。当我尝试打开它时,窗口只会出现一秒钟就消失了。 - Aminah Nuraini

0

您可以从源代码下载二进制文件:

https://www.lfd.uci.edu/~gohlke/pythonlibs/

在 Python 版本 cp[python version] 和架构 win_[architecture] 下,下载并安装:

pip install wheel

pip install mysqlclient‑1.3.12‑cp36‑cp36m‑win_amd64.whl

不要使用官方的 Python MySQL 连接器,它通常比 mysql-python 慢 2 倍!


MySQL_python-1.2.5-cp27-none-win_amd64.whl不支持此平台。我正在使用Windows 10(x64)专业版。 - user2063329

网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接