Cfrgtkky

I am new to python and I am trying django framework that involves some MySql and ran into this error when try to do pip install mysqlclient and down the lines of cmd messages I got this.

   Failed building wheel for mysqlclient

  Running setup.py clean for mysqlclient

Failed to build mysqlclient

Installing collected packages: mysqlclient

  Running setup.py install for mysqlclient ... error

    Complete output from command c:usersronanl~1envspy1scriptspython.exe -u -c "import setuptools, tokenize;__file__='C:\Users\RONANL~1\AppData\Local\Temp\pip-install-pkbqy3t3\mysqlclient\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('rn', 'n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:UsersRONANL~1AppDataLocalTemppip-record-moxwf7luinstall-record.txt --single-version-externally-managed --compile --install-headers c:usersronanl~1envspy1includesitepython3.7mysqlclient:

    running install

    running build

    running build_py

    creating build

    creating buildlib.win32-3.7

    copying _mysql_exceptions.py -> buildlib.win32-3.7

    creating buildlib.win32-3.7MySQLdb

    copying MySQLdb__init__.py -> buildlib.win32-3.7MySQLdb

    copying MySQLdbcompat.py -> buildlib.win32-3.7MySQLdb

    copying MySQLdbconnections.py -> buildlib.win32-3.7MySQLdb

    copying MySQLdbconverters.py -> buildlib.win32-3.7MySQLdb

    copying MySQLdbcursors.py -> buildlib.win32-3.7MySQLdb

    copying MySQLdbrelease.py -> buildlib.win32-3.7MySQLdb

    copying MySQLdbtimes.py -> buildlib.win32-3.7MySQLdb

    creating buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstants__init__.py -> buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstantsCLIENT.py -> buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstantsCR.py -> buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstantsER.py -> buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstantsFIELD_TYPE.py -> buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstantsFLAG.py -> buildlib.win32-3.7MySQLdbconstants

    copying MySQLdbconstantsREFRESH.py -> buildlib.win32-3.7MySQLdbconstants

    running build_ext

    building '_mysql' extension

    creating buildtemp.win32-3.7

    creating buildtemp.win32-3.7Release

    C:Program Files (x86)Microsoft Visual Studio2017CommunityVCToolsMSVC14.14.26428binHostX86x86cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,3,13,'final',0) -D__version__=1.3.13 "-IC:Program Files (x86)MySQLMySQL Connector C 6.1include" "-Ic:usersronan linaappdatalocalprogramspythonpython37-32include" "-Ic:usersronan linaappdatalocalprogramspythonpython37-32include" "-IC:Program Files (x86)Microsoft Visual Studio2017CommunityVCToolsMSVC14.14.26428ATLMFCinclude" "-IC:Program Files (x86)Microsoft Visual Studio2017CommunityVCToolsMSVC14.14.26428include" "-IC:Program Files (x86)Windows KitsNETFXSDK4.6.1includeum" "-IC:Program Files (x86)Windows Kits10include10.0.17134.0ucrt" "-IC:Program Files (x86)Windows Kits10include10.0.17134.0shared" "-IC:Program Files (x86)Windows Kits10include10.0.17134.0um" "-IC:Program Files (x86)Windows Kits10include10.0.17134.0winrt" "-IC:Program Files (x86)Windows Kits10include10.0.17134.0cppwinrt" /Tc_mysql.c /Fobuildtemp.win32-3.7Release_mysql.obj /Zl

    _mysql.c

    _mysql.c(29): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory

    error: command 'C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.14.26428\bin\HostX86\x86\cl.exe' failed with exit status 2

> 

> 

> Command "c:usersronanl~1envspy1scriptspython.exe -u -c "import setuptools, tokenize;__file__='C:\Users\RONANL~1\AppData\Local\Temp\pip-install-pkbqy3t3\mysqlclient\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('rn', 'n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:UsersRONANL~1AppDataLocalTemppip-record-moxwf7luinstall-record.txt --single-version-externally-managed --compile --install-headers c:usersronanl~1envspy1includesitepython3.7mysqlclient" failed with error code 1 in C:UsersRONANL~1AppDataLocalTemppip-install-pkbqy3t3mysqlclient

anyone knows how to fix this ?

currently the mysql-connector for python 3.7 is not available in official wesite but u can fix this issue by installing wheel with specific windows and python version.
this solutionpip install (ex/dir)/mysqlclient-1.3.13-cp37-cp37m-win_amd64.whl for win 64-bi and python 3.7

check the link below and download the specific wheel for your system.
download and install the wheel for specific version by using "pip install (full path with file name in my case ex:-"pip install C:Users%user%Downloadsmysqlclient-1.3.13-cp37-cp37m-win_amd64.whl")

Use Anaconda and execute
conda install mysqlclient