https://stackoverflow.com/questions/26866147/mysql-python-install-error-cannot-open-include-file-config-win-h

72 45

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

python mysql mysql-python failed-installation share improve this questionfollow edited  Oct 23 '17 at 18:11 Stevoisiak 12.4k1313 gold badges8484 silver badges136136 bronze badges asked  Nov 11 '14 at 13:34 Chris Meek 1,19344 gold badges1515 silver badges2727 bronze badges

• 4 Take a look at this : stackoverflow.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

add a comment

8 Answers

ActiveOldestVotes 156  

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.whl

  For python 2.7:

  pip install mysqlclient-1.3.8-cp27-cp27m-win_amd64.whl

share improve this answerfollow edited  Nov 16 '16 at 9:52 fmicand 333 bronze badges answered  Jun 26 '15 at 15:31 pokemon blue 1,76411 gold badge1010 silver badges1818 bronze badges

• 5 This 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
• 22 I 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
• 3 I 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

show  16 more comments 51

This didnt work for me:

pip install mysqlclient

so i found this after a while on stackoverflow:

pip install --only-binary :all: mysqlclient

and 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

share improve this answerfollow edited  Sep 3 '18 at 11:52     answered  Aug 12 '18 at 17:44 kaya 1,32511 gold badge1616 silver badges2020 bronze badges

• 3 I 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
• 1 Only this worked for me (I am also using w10). Thank you. – JCarlosR Sep 5 '18 at 20:04
• 1 awesome, 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
• 1 Thank you very much this! – iampotential Sep 6 '19 at 14:01
• 1 Thanks. This is the only one that helped – Kshitij G Jan 31 at 20:32

show  1 more comment 11

well this worked for me:

pip install mysqlclient

this is for python 3.x in window 7 i am not sure about other windows os versions

share improve this answerfollow answered  Mar 18 '17 at 9:03 kinsley kajiva 1,44711 gold badge1515 silver badges2222 bronze badges

•   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
• 1 Worked on Windows 10 also – user1575148 Aug 23 '19 at 14:14

add a comment 9

You can try...

 pip install mysqlclient==1.3.4

It worked for me.

If the above command doesn't work try this...

 pip install --only-binary :all: mysqlclient

both worked for me.

share improve this answerfollow