Python 安装mysqlclient 错误MySQLdb/_mysql.c(29): fatal error C1083: 无法打开包括文件: “mysql.h”: 解决方法

刺骨的言语ヽ痛彻心扉 2021-09-07 20:38 2195阅读 1赞

错误提示：

> ERROR: Command errored out with exit status 1:  
> command: ‘c:\\users\\30452\\appdata\\local\\programs\\python\\python38-32\\python.exe’  
> \-u -c ‘import io , os, sys, setuptools, tokenize; sys.argv\[0\] = ‘"’"‘C:\\Users\\30452\\AppData\\Local\\Temp\\pip-inst  
> all-d6s\_2g4l\\mysqlclient\_2da381d847214b0193d0cd589a21eaa2\\setup.py’"’"’;  
> **file**=’"’"‘C:\\Users\\ 30452\\AppData\\Local\\Temp\\pip-install-d6s\_2g4l\\mysqlclient\_2da381d847214b0193d0cd589a21eaa2\\set  
> up.py’"’"’;f = getattr(tokenize, ‘"’"‘open’"’"’, open)(**file**) if  
> os.path.exists(**file**) else io .StringIO(’"’"‘from setuptools import  
> setup; setup()’"’"’);code = f.read().replace(’"’"’\\r\\n’"’"’, ’  
> “’”’\\n’"’"’);f.close();exec(compile(code, **file**, ‘"’"‘exec’"’"’))’  
> install --record ‘C:\\Users\\304  
> 52\\AppData\\Local\\Temp\\pip-record-excl1aq1\\install-record.txt’  
> –single-version-externally-managed – compile --install-headers ‘c:\\users\\30452\\appdata\\local\\programs\\python\\python38-32\\Include\\mysqlcli  
> ent’  
> cwd: C:\\Users\\30452\\AppData\\Local\\Temp\\pip-install-d6s\_2g4l\\mysqlclient\_2da381d847214b0193d  
> 0cd589a21eaa2  
> Complete output (31 lines):  
> Error in sitecustomize; set PYTHONVERBOSE for traceback:  
> AttributeError: module ‘sys’ has no attribute ‘setdefaultencoding’  
> running install  
> running build  
> running build\_py  
> creating build  
> creating build\\lib.win32-3.8  
> creating build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\_*init*\_.py -> build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\_exceptions.py -> build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\\connections.py -> build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\\converters.py -> build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\\cursors.py -> build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\\release.py -> build\\lib.win32-3.8\\MySQLdb  
> copying MySQLdb\\times.py -> build\\lib.win32-3.8\\MySQLdb  
> creating build\\lib.win32-3.8\\MySQLdb\\constants  
> copying MySQLdb\\constants\_*init*\_.py -> build\\lib.win32-3.8\\MySQLdb\\constants  
> copying MySQLdb\\constants\\CLIENT.py -> build\\lib.win32-3.8\\MySQLdb\\constants  
> copying MySQLdb\\constants\\CR.py -> build\\lib.win32-3.8\\MySQLdb\\constants  
> copying MySQLdb\\constants\\ER.py -> build\\lib.win32-3.8\\MySQLdb\\constants  
> copying MySQLdb\\constants\\FIELD\_TYPE.py -> build\\lib.win32-3.8\\MySQLdb\\constants  
> copying MySQLdb\\constants\\FLAG.py -> build\\lib.win32-3.8\\MySQLdb\\constants  
> running build\_ext  
> building ‘MySQLdb.*mysql’ extension  
> creating build\\temp.win32-3.8  
> creating build\\temp.win32-3.8\\Release  
> creating build\\temp.win32-3.8\\Release\\MySQLdb  
> C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Community\\VC\\Tools\\MSVC\\14.25.28610\\bin\\Host  
> X86\\x86\\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD  
> \-Dversion\_info=(2,0,3,‘final’,0) -D\_\_version*\_=2.  
> 0.3 “-IC:\\Program Files (x86)\\MySQL\\MySQL Connector C 6.1\\include\\mariadb” -Ic:\\users\\30452\\appdata\\ local\\programs\\python\\python38-32\\include  
> \-Ic:\\users\\30452\\appdata\\local\\programs\\python\\python38-32 \\include “-IC:\\Program Files (x86)\\Microsoft Visual  
> Studio\\2019\\Community\\VC\\Tools\\MSVC\\14.25.28610\\ ATLMFC\\include”  
> “-IC:\\Program Files (x86)\\Microsoft Visual  
> Studio\\2019\\Community\\VC\\Tools\\MSVC\\14.25 .28610\\include”  
> “-IC:\\Program Files (x86)\\Windows Kits\\NETFXSDK\\4.8\\include\\um”  
> “-IC:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\ucrt”  
> “-IC:\\Program Files (x86)\\Windows Kits\\10\\include\\1  
> 0.0.18362.0\\shared” “-IC:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\um” “-IC:\\Program Files (x86)\\Windows  
> Kits\\10\\include\\10.0.18362.0\\winrt” “-IC:\\Program Files (x86)\\Windows  
> Kits\\10\\i nclude\\10.0.18362.0\\cppwinrt” /TcMySQLdb/\_mysql.c  
> /Fobuild\\temp.win32-3.8\\Release\\MySQLdb/\_mysql.obj  
> \_mysql.c  
> MySQLdb/\_mysql.c(29): fatal error C1083: 无法打开包括文件: “mysql.h”: No such file or director y  
> error: command ‘C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Community\\VC\\Tools\\MS  
> VC\\14.25.28610\\bin\\HostX86\\x86\\cl.exe’ failed with exit status 2  
> \---------------------------------------- ERROR: Command errored out with exit status 1:  
> ‘c:\\users\\30452\\appdata\\local\\programs\\python\\python3 8-32\\python.exe’  
> \-u -c ‘import io, os, sys, setuptools, tokenize; sys.argv\[0\] = ‘"’"‘C:\\Users\\3045  
> 2\\AppData\\Local\\Temp\\pip-install-d6s\_2g4l\\mysqlclient\_2da381d847214b0193d0cd589a21eaa2\\setup.py’"’"’;  
> **file**=’"’"‘C:\\Users\\30452\\AppData\\Local\\Temp\\pip-install-d6s\_2g4l\\mysqlclient\_2da381d847214b  
> 0193d0cd589a21eaa2\\setup.py’"’"’;f = getattr(tokenize,  
> ‘"’"‘open’"’"’, open)(**file**) if os.path.exists(**file**) else  
> io.StringIO(’"’"‘from setuptools import setup; setup()’"’"’);code =  
> f.read().replace(’"’" ‘\\r\\n’"’"’,  
> ‘"’"’\\n’"’"’);f.close();exec(compile(code, **file**, ‘"’"‘exec’"’"’))’  
> install --record  
> ‘C:\\Users\\30452\\AppData\\Local\\Temp\\pip-record-excl1aq1\\install-record.txt’  
> –single-version-externally-managed --compile --install-headers ‘c:\\users\\30452\\appdata\\local\\programs\\python\\python38-32\\Include\\mysqlclient’  
> Check the logs for full command output  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQwMzYzMg_size_16_color_FFFFFF_t_70]

打开网页：https://www.lfd.uci.edu/~gohlke/pythonlibs  
https://www.lfd.uci.edu/~gohlke/pythonlibs/\#mysqlclient  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQwMzYzMg_size_16_color_FFFFFF_t_70 1]cp39-cp39 cp后面数字代表Python版本  
win32 代表Python为32位  
下载对应版本  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQwMzYzMg_size_16_color_FFFFFF_t_70 2]cd 进入下载的文件目录  
pip install +文件名进行安装

其他包安装失败 方法通用

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQwMzYzMg_size_16_color_FFFFFF_t_70]: /images/20210813/16ed6d7d1bcf482aa6582b56a8cc27a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQwMzYzMg_size_16_color_FFFFFF_t_70 1]: /images/20210813/b73c62cf49b840f2a92ec02114e87d54.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQwMzYzMg_size_16_color_FFFFFF_t_70 2]: /images/20210813/989200e0933547d98ce391edd52facf4.png