mysql 193 oxcl_在Windows上安装Python 3.7/MySQL连接器失败：_MySQL.c（29）：致命错误C1083:无法打开包含文件：“MySQL.h”：没有此类文件或目录...

因此，我使用Python 3.7并尝试使用以下方式安装MYSQL连接器：

pip install mysqlclient，但得到以下错误：Failed building wheel for mysqlclient

Running setup.py clean for mysqlclient

Failed to build mysqlclient

Installing collected packages: mysqlclient

Running setup.py install for mysqlclient ... error

Complete output from command c:\users\mariak~1\envs\py1\scripts\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\MARIAK~1\\AppData\\Local\\Temp\\pip-install-maurmpl9\\mysqlclient\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\MARIAK~1\AppData\Local\Temp\pip-record-kh605r0i\install-record.txt --single-version-externally-managed --compile --install-headers c:\users\mariak~1\envs\py1\include\site\python3.7\mysqlclient:

running install

running build

running build_py

creating build

creating build\lib.win32-3.7

copying _mysql_exceptions.py -> build\lib.win32-3.7

creating build\lib.win32-3.7\MySQLdb

copying MySQLdb\__init__.py -> build\lib.win32-3.7\MySQLdb

copying MySQLdb\compat.py -> build\lib.win32-3.7\MySQLdb

copying MySQLdb\connections.py -> build\lib.win32-3.7\MySQLdb

copying MySQLdb\converters.py -> build\lib.win32-3.7\MySQLdb

copying MySQLdb\cursors.py -> build\lib.win32-3.7\MySQLdb

copying MySQLdb\release.py -> build\lib.win32-3.7\MySQLdb

copying MySQLdb\times.py -> build\lib.win32-3.7\MySQLdb

creating build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\__init__.py -> build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\CR.py -> build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\ER.py -> build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.7\MySQLdb\constants

copying MySQLdb\constants\REFRESH.py -> build\lib.win32-3.7\MySQLdb\constants

running build_ext

building '_mysql' extension

creating build\temp.win32-3.7

creating build\temp.win32-3.7\Release

C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\bin\HostX86\x86\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,3,13,'final',0) -D__version__=1.3.13 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.1\include" "-Ic:\users\maria kuona\appdata\local\programs\python\python37-32\include" "-Ic:\users\maria kuona\appdata\local\programs\python\python37-32\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\include" /Tc_mysql.c /Fobuild\temp.win32-3.7\Release\_mysql.obj /Zl

_mysql.c

_mysql.c(29): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory

error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.14.26428\\bin\\HostX86\\x86\\cl.exe' failed with exit status 2**

我安装了最新的VStudio构建工具2017。可能是什么问题，我如何纠正它。在