pip – Installing mysqlclient in Python 3.6 in windows

pip – Installing mysqlclient in Python 3.6 in windows

Had the same problem, searched the web etc. Here this answer:

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

It has all the instructions. In short go to this site: https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient:

At that website you will find
mysqlclient‑1.3.13‑cp36‑cp36m‑win32.whl
mysqlclient‑1.3.13‑cp36‑cp36m‑win_amd64.whl

Download the correct file for your platform.

Then use your downloaded wheels file with pip and youre done:

pip install c:mysqlclient‑1.3.13‑cp36‑cp36m‑win_amd64.whl

The https://www.lfd.uci.edu/~gohlke/pythonlibs has lots of lots of compiled libraries to solve the problem of building them from source yourself. They even compile them for python 3.7 🙂

Alternative Solution

You can also download Visual C++ Build Tools and then you should be able to install every (at least to my knowledge) version of mysqlclient with pip.

To do this go to this site: https://www.scivision.co/python-windows-visual-c++-14-required/ there you can find out which version of Build Tools you need and you can also find a link to download the installer. Be aware though Build Tools require more than 4GB of free disk space.

I cant find mysqlclient-1.3.13s whl file on PyPi. So you need to compile it from source. Unfortunately its not easy. Im not Windows guy, so I only can recommend guide like this

pip – Installing mysqlclient in Python 3.6 in windows

I am using python3.7 on Windows 10 operating system.
I had same issue and after a long research I had installed it successfully.

Install Microsoft Visual C++ Build Tools
AND
My OS is having 64 bit operating system but still then it need to install 32 bit version
mysqlclient‑1.4.2‑cp37‑cp37m‑win32.whl

Download binary wheels from https://www.lfd.uci.edu/~gohlke/pythonlibs/ and run command

pip install [path_to_downloaded_file] eg: C:UsersDsmysqlclient-1.4.2-cp37-cp37m-win32.whl

use pipenv instead of pip if you are using virtual environment.

Leave a Reply

Your email address will not be published.