https://*.com/questions/26866147/mysql-python-install-error-cannot-open-include-file-config-win-h
I am trying to run pip install mysql-python connector but it keeps giving me an error "Cannot open include file: ‘config-win.h‘".
The installation works fine on my Mac and another Windows machine, but not this one. I have downloaded Visual Studio C++ and tried installing as both 32 bit and 64.
_mysql.c(42) : fatal error C1083: Cannot open include file: ‘config-win.h‘: No s
uch file or directory
error: command ‘C:\\Program Files (x86)\\Microsoft Visual Studio 9.0\\VC\\BIN\\c
l.exe‘ failed with exit status 2
----------------------------------------
Cleaning up...
Command C:\Users\Admin1\Desktop\python\virtual\Scripts\python.exe -c "import set
uptools, tokenize;__file__=‘C:\\Users\\Admin1\\Desktop\\python\\virtual\\build\MySQL-python\\setup.py‘;exec(compile(getattr(tokenize, ‘open‘, open)(__file__).r
ead().replace(‘\r\n‘, ‘\n‘), __file__, ‘exec‘))" install --record c:\users\admin
1\appdata\local\temp\1\pip-6pmwrd-record\install-record.txt --single-version-ext
ernally-managed --compile --install-headers C:\Users\Admin1\Desktop\python\virtu
al\include\site\python2.7 failed with error code 1 in C:\Users\Admin1\Desktop\py
thon\virtual\build\MySQL-python
Storing debug log for failure in C:\Users\Admin1\pip\pip.log-
4Take a look at this : *.com/questions/1972259/… – Alexander Nov 11 ‘14 at 13:37
-
try to install it from an executable setup file. (it‘s force installation and sometimes ignores the error). – Reza-S4 Apr 16 ‘15 at 5:30
for 64-bit windows
-
install using wheel
pip install wheel -
download from http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python
For python 3.x:
pip install mysqlclient-1.3.8-cp36-cp36m-win_amd64.whlFor python 2.7:
pip install mysqlclient-1.3.8-cp27-cp27m-win_amd64.whl
-
5This was successful for me with all versions. Also make sure to download the .whl file to the same directory you execute the pip install call from. – sir_gelato Jul 26 ‘15 at 6:07
-
22I am getting this error: MySQL_python-1.2.5-cp27-none-win32.whl is not a supported wheel on this platform. Any help? – Vivek Sep 19 ‘16 at 20:01
-
3I tried the other one also: MySQL_python-1.2.5-cp27-none-win_amd64.whl is not a supported wheel on this platform. It did not work – Vivek Sep 19 ‘16 at 20:02
-
3@CodeFarmer how it connected ? I am getting an error
not a supported wheel on this platform– ojus kulkarni Jan 7 ‘17 at 21:15 -
3@ojuskulkarni you may try install a wrong version of wheel, carefuly chose the one suit your enviroment e.g python version, 32bit/64bit need same with your python bit version not system. – Bucketcode Jan 9 ‘17 at 1:44
This didnt work for me:
pip install mysqlclientso i found this after a while on *:
pip install --only-binary :all: mysqlclientand it went all through, no need for MS Visual C++ 14 Build tools and stuff
Note: for now this doesnt work with Python3.7, i also had to downgrade to Python 3.6.5
-
3I have been having the same issue on Windows 10 - this worked for me, thank you very much +1 – The-WebGuy Aug 12 ‘18 at 21:12
-
1Only this worked for me (I am also using w10). Thank you. – JCarlosR Sep 5 ‘18 at 20:04
-
1awesome, it really worked for me after finding a solution for 3-4 days. I am also on 64-bit Windows 10 – Zaheer Sep 24 ‘18 at 12:50
-
1Thank you very much this! – iampotential Sep 6 ‘19 at 14:01
-
1Thanks. This is the only one that helped – Kshitij G Jan 31 at 20:32
well this worked for me:
pip install mysqlclientthis is for python 3.x in window 7 i am not sure about other windows os versions
-
Further note that the module is named MySQLdb so use
import MySQLdb. – Nae Feb 26 ‘18 at 10:51 -
This fails on 64 bit python on Windows 10, installed via anaconda. After installing visual studio tools it still failed and seems unable to find the headers for 64 bit connector. – Ralph Ritoch Oct 19 ‘18 at 10:51
-
1Worked on Windows 10 also – user1575148 Aug 23 ‘19 at 14:14
You can try...
pip install mysqlclient==1.3.4It worked for me.
If the above command doesn‘t work try this...
pip install --only-binary :all: mysqlclientboth worked for me.
mysql-python install error: Cannot open include file 'config-win.h'