Error with pip install MySQLdb library

Question

In python 2.7.10, Could not find a version that satisfies the requirement mysqldb(from version) no matching distribution found for mysqldb

pip install MySQL-python also failed: Unable to find vcvarsall.bat and many other errors if I am patching solution for this one.

Are you on Windows? – ChrisGPT was on strike Jul 24 '16 at 11:41 — ChrisGPT was on strike, Jul 24 '16 at 11:41
yes, Windows versions 7/8/8.1/10. – nivhanin Jul 24 '16 at 11:43 — nivhanin, Jul 24 '16 at 11:43

score 2 · Accepted Answer · answered Jul 24 '16 at 11:52

Building Python libraries on Windows can be challenging.

This message indicates that the Visual C++ compiler cannot be found:

Unable to find vcvarsall.bat

You could install Visual Studio Express and try again, or use another compiler as suggested in the referenced question. But you may find that this leads to further problems, e.g. now the MySQL headers can't be found.

Manually installing MySQL from source will likely fix that issue, but that might reveal its own dependency problems.

Instead of going through this rigmarole you might consider installing precompiled versions from Christoph Gohlke.

@nivhanin, that's a different driver but it should work. The page I referenced in my answer contains many useful Python libraries, not just a MySQL driver. — ChrisGPT was on strike, Jul 24 '16 at 13:05

Error with pip install MySQLdb library

1 Answers1