Python MySQLdb "error: Microsoft Visual C++ 14.0 is required" even though it has been installed

Question

I'm attempting to connect to a MySql database and use its data for some code, though when I'm using

pip install mysqlclient

it gives me an error stating:

"error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": http://landinghub.visualstudio.com/visual-cpp-build-tools"

This link provided does not work, though i found out the correct link and installed the build tools as well as the "Windows 10 SDK" as other posts have specified. I sadly still am getting this error.

Anyone know what is wrong? Thanks!

user_10202259 · Answer

It's a complicated environment.

I suggest to use pyodbc to connect to your database ( it isn't required by c++ compiler installation)

Try to convert the below code in your program

import pyodbc

conn = pyodbc.connect('DRIVER={MySQL};SOCKET=/var/lib/mysql/mysql.sock;UID=rooter;PWD=sshh')

user_10199864 · Answer

Try this:

1- Download mysqlclient wheel on Unoffical Windows Binaries for Python Extension Packages. (search for mysqlclient-1.3.13-cp37-cp37m-win32)

2- Install manually pip install mysqlclient-1.3.13-cp37-cp37m-win32.whl

user_944224 · Answer

I believe if you need MySQL database, this is installed by other means i.e. see Microsoft webpage for details (https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html).

If you just want to connect to MySQL database from Python, try installing mysql-connector instead.

pip install mysql-connector

Python MySQLdb "error: Microsoft Visual C++ 14.0 is required" even though it has been installed

3 Answers