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