optionnally mysql_mysql-python install error: Cannot open include file 'config-win.h'

mysql-python install error: Cannot open include file 'config-win.h'

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:Cannotopen include file:'config-win.h':Nos

uch file ordirectory

error:command 'C:\\Program Files (x86)\\Microsoft Visual Studio 9.0\\VC\\BIN\\c

l.exe'failed withexitstatus 2----------------------------------------Cleaningup...CommandC:\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.7failed witherror code 1inC:\Users\Admin1\Desktop\py

thon\virtual\build\MySQL-python

Storingdebug log forfailure inC:\Users\Admin1\pip\pip.log

python mysql mysql-python failed-installation

shareimprove 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

shareimprove 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

shareimprove 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

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

shareimprove this answerfollow