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

Question

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

Take a look at this : stackoverflow.com/questions/1972259/… – Alexander Nov 11 '14 at 13:37 — 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 — Reza-S4, Apr 16 '15 at 5:30

fmicand · Accepted Answer · 2016-11-16 09:52:24Z

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

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

kaya · Answer 2 · 2018-09-03 11:52:38Z

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

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

kinsley kajiva · Answer 3 · 2017-03-18 09:03:29Z

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

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

score 9 · Answer 4

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.

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

8 Answers

公告