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:UsersAdmin1DesktoppythonvirtualScriptspython.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('
', '
'), __file__, 'exec'))" install --record c:usersadmin
1appdatalocalemp1pip-6pmwrd-recordinstall-record.txt --single-version-ext
ernally-managed --compile --install-headers C:UsersAdmin1Desktoppythonvirtu
alincludesitepython2.7 failed with error code 1 in C:UsersAdmin1Desktoppy
thonvirtualuildMySQL-python
Storing debug log for failure in C:UsersAdmin1pippip.log

Answer 1

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