stackoverflow Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat )

I have installed Python 3.6 and while running

pip install mysql-python

it gives me the following error

error: Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat)

I have a 32bit win 10 setup in my PC.

What could be the solution for mitigating this error and installing the modules correctly via pip.

solution 1

Use this link to download Visual C++ 2015 Build Tools. It will install Visual C++ 14.0 without installing Visual Studio. After the installation completes, retry pip install and you won not get the error again

solution 2

As the solution 1 pointed out, one solution is to install Visual Studio 2015. However, it takes a few GBs of disk space. One way around is to install precompiled binaries. The webpage http://www.lfd.uci.edu/~gohlke/pythonlibs contains precompiled binaries for many Python packages. After downloading the package of interest to you, you can install it using pip install,
Such as this mysqlclient‑1.4.6‑cp36‑cp36m‑win32.whl

pip install mysqlclient‑1.4.6‑cp36‑cp36m‑win32.whl

source: https://stackoverflow.com/questions/29846087/microsoft-visual-c-14-0-is-required-unable-to-find-vcvarsall-bat/51087608