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

for 64-bit windows

  • install using wheel
     pip install wheel

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

From: stackoverflow.com/q/26866147

Back to homepage or read more recommendations: