Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)
edited by

I am new to the python and I am trying Django framework that involves some MySQL and got into this error when I was trying to do pip install mysqlclient and down the lines of cmd messages, I am getting the following.

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:\users\ronanl~1\envs\py1\scripts\python.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('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\RONANL~1\AppData\Local\Temp\pip-record-moxwf7lu\install-record.txt --single-version-externally-managed --compile --install-headers c:\users\ronanl~1\envs\py1\include\site\python3.7\mysqlclient:

    running install

    running build

    running build_py

    creating build

    creating build\lib.win32-3.7

    copying _mysql_exceptions.py -> build\lib.win32-3.7

    creating build\lib.win32-3.7\MySQLdb

    copying MySQLdb\__init__.py -> build\lib.win32-3.7\MySQLdb

    copying MySQLdb\compat.py -> build\lib.win32-3.7\MySQLdb

    copying MySQLdb\connections.py -> build\lib.win32-3.7\MySQLdb

    copying MySQLdb\converters.py -> build\lib.win32-3.7\MySQLdb

    copying MySQLdb\cursors.py -> build\lib.win32-3.7\MySQLdb

    copying MySQLdb\release.py -> build\lib.win32-3.7\MySQLdb

    copying MySQLdb\times.py -> build\lib.win32-3.7\MySQLdb

    creating build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\__init__.py -> build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\CLIENT.py -> build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\CR.py -> build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\ER.py -> build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\FLAG.py -> build\lib.win32-3.7\MySQLdb\constants

    copying MySQLdb\constants\REFRESH.py -> build\lib.win32-3.7\MySQLdb\constants

    running build_ext

    building '_mysql' extension

    creating build\temp.win32-3.7

    creating build\temp.win32-3.7\Release

    C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.14.26428\bin\HostX86\x86\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,3,13,'final',0) -D__version__=1.3.13 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.1\include" "-Ic:\users\ronan lina\appdata\local\programs\python\python37-32\include" "-Ic:\users\ronan lina\appdata\local\programs\python\python37-32\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.14.26428\ATLMFC\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.14.26428\include" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\winrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\cppwinrt" /Tc_mysql.c /Fobuild\temp.win32-3.7\Release\_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:\users\ronanl~1\envs\py1\scripts\python.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('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\RONANL~1\AppData\Local\Temp\pip-record-moxwf7lu\install-record.txt --single-version-externally-managed --compile --install-headers c:\users\ronanl~1\envs\py1\include\site\python3.7\mysqlclient" failed with error code 1 in C:\Users\RONANL~1\AppData\Local\Temp\pip-install-pkbqy3t3\mysqlclient\

Does anyone know how to fix this?

1 Answer

0 votes
by (12.7k points)

I have installed the following library on Ubuntu and after that, the issue got resolved.

sudo apt-get install libssl-dev

and then I was able to install mysqlclient using the following command.

pip install mysqlclient

Are you interested to learn SQL in detail? Register for the SQL Certification program. 

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...