python2.7 安装MYSQL-python 报错:ERROR: Command errored out with exit status 1:

小灰灰 2024-04-18 18:54 72阅读 0赞

***python2.7 安装MYSQL-python 报错***

Running setup.py install for MYSQL-python … error  
ERROR: Command errored out with exit status 1:  
command: ‘d:\\program files\\python\\python27\\python2.exe’ -u -c ‘import sys, setuptools, tokenize; sys.argv\[0\] = ‘"’"‘c:\\users\\admini~1\\appdata\\local\\temp\\pip-install-bdgfxb\\MYSQL-python\\setup.py’"’"’; **file**=’"’"‘c:\\users\\admini~1\\appdata\\local\\temp\\pip-install-bdgfxb\\MYSQL-python\\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\\admini~1\\appdata\\local\\temp\\pip-record-ynhh7j\\install-record.txt’ --single-version-externally-managed --compile  
cwd: c:\\users\\admini~1\\appdata\\local\\temp\\pip-install-bdgfxb\\MYSQL-python  
Complete output (29 lines):  
running install  
running build  
running build\_py  
creating build  
creating build\\lib.win-amd64-2.7  
copying *mysql\_exceptions.py -> build\\lib.win-amd64-2.7  
creating build\\lib.win-amd64-2.7\\MySQLdb  
copying MySQLdb\_init*.py -> build\\lib.win-amd64-2.7\\MySQLdb  
copying MySQLdb\\converters.py -> build\\lib.win-amd64-2.7\\MySQLdb  
copying MySQLdb\\connections.py -> build\\lib.win-amd64-2.7\\MySQLdb  
copying MySQLdb\\cursors.py -> build\\lib.win-amd64-2.7\\MySQLdb  
copying MySQLdb\\release.py -> build\\lib.win-amd64-2.7\\MySQLdb  
copying MySQLdb\\times.py -> build\\lib.win-amd64-2.7\\MySQLdb  
creating build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\_*init*\_.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\\CR.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\\FIELD\_TYPE.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\\ER.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\\FLAG.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\\REFRESH.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
copying MySQLdb\\constants\\CLIENT.py -> build\\lib.win-amd64-2.7\\MySQLdb\\constants  
running build\_ext  
building ‘*mysql’ extension  
creating build\\temp.win-amd64-2.7  
creating build\\temp.win-amd64-2.7\\Release  
C:\\Users\\Administrator\\AppData\\Local\\Programs\\Common\\Microsoft\\Visual C++ for Python\\9.0\\VC\\Bin\\amd64\\cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -Dversion\_info=(1,2,5,‘final’,1) -D\_\_version*\_=1.2.5 “-IC:\\Program Files (x86)\\MySQL\\MySQL Connector C 6.0.2\\include” “-Id:\\program files\\python\\python27\\include” “-Id:\\program files\\python\\python27\\PC” /Tc\_mysql.c /Fobuild\\temp.win-amd64-2.7\\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:\\Users\\Administrator\\AppData\\Local\\Programs\\Common\\Microsoft\\Visual C++ for Python\\9.0\\VC\\Bin\\amd64\\cl.exe’ failed with exit status 2  
\----------------------------------------  
ERROR: Command errored out with exit status 1: ‘d:\\program files\\python\\python27\\python2.exe’ -u -c ‘import sys, setuptools, tokenize; sys.argv\[0\] = ‘"’"‘c:\\users\\admini~1\\appdata\\local\\temp\\pip-install-bdgfxb\\MYSQL-python\\setup.py’"’"’; **file**=’"’"‘c:\\users\\admini~1\\appdata\\local\\temp\\pip-install-bdgfxb\\MYSQL-python\\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\\admini~1\\appdata\\local\\temp\\pip-record-ynhh7j\\install-record.txt’ --single-version-externally-managed --compile Check the logs for full command output.![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70]

在python下安装MySQL-python遇到的大坑：尝试了源码安装，pip install安装，始终无法安装成功，最终解决办法是通过以下方法：

**1.[https://www.lfd.uci.edu/~gohlke/pythonlibs/\#mysql-python][https_www.lfd.uci.edu_gohlke_pythonlibs_mysql-python] 下载MySQL-python或者是Mysqlclient的.whl包，注意对应自己安装的python版本,如何使32 bit就下载对应32位的版本；**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70 1]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70 2]

**2.通过pip install对应的.whl就可以看到安装成功了，然后import MySQLdb,发现已经不报错了；**

C:\\Users\\Administrator\\Desktop>pip install C:\\Users\\Administrator\\Desktop\\mysqlc  
lient-1.3.12-cp27-cp27m-win32.whl  
Processing c:\\users\\administrator\\desktop\\mysqlclient-1.3.12-cp27-cp27m-win32.wh  
l  
Installing collected packages: mysqlclient

Successfully installed mysqlclient-1.3.12

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70 3]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/8078a93d7e1947ecb233c6a6d766d50e.png
[https_www.lfd.uci.edu_gohlke_pythonlibs_mysql-python]: https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/65e4a23f4c5e4a10be0b3fd05286ef1b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/b1cf064dd0dd4f6a9d48290370d65aa8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyMjgxNDU_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f279a3bc593a46e4b26c2bb9493cb8ae.png