pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory

by

You can download unofficial windows binaries for your python version using https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient. Then install it using pip. This way you’ll be able to avoid the hassle of dealing with visual studio build tools.

Just download the mysqlclient.whl file most applicable to you. I think in your case it’ll be

mysqlclient‑1.3.13‑cp36‑cp36m‑win_amd64.whl

and run 

pip install "path to the downloaded .whl file"

More Related Contents:

  1. Installing specific package version with pip
  2. How to install Python MySQLdb module using pip?
  3. Not all parameters were used in the SQL statement (Python, MySQL)
  4. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  5. Using a Python dict for a SQL INSERT statement
  6. Insert list into my database using Python [duplicate]
  7. Python Pandas write to sql with NaN values
  8. Dynamic SQL Queries with Python and mySQL
  9. pip install mysqlclient : Microsoft Visual C++ 14.0 is required
  10. ‘pip install MySQL-python’ fails with ‘IndexError’
  11. “pip install unroll”: “python setup.py egg_info” failed with error code 1
  12. How can I connect to MySQL in Python 3 on Windows?
  13. How to add a custom CA Root certificate to the CA Store used by pip in Windows?
  14. Can’t install new packages for Python (Python 3.9.0, Windows 10)
  15. How to install Python package from GitHub? [duplicate]
  16. How to uninstall a package installed with pip install –user
  17. memory-efficient built-in SqlAlchemy iterator/generator?
  18. How can I get dict from sqlite query?
  19. Why can I not create a wheel in python?
  20. When to close cursors using MySQLdb
  21. Python, Error while installing matplotlib
  22. django installation: cannot use pip to install django on linux(ubuntu)
  23. pip throws TypeError: parse() got an unexpected keyword argument ‘transport_encoding’ when trying to install new packages
  24. Trouble installing TextBlob with pip
  25. Can’t install PIL after Mac OS X 10.9
  26. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  27. Could not find a version that satisfies the requirement for select requirements
  28. pymysql fetchall() results as dictionary?
  29. Install mysqlclient for Django Python on Mac OS X Sierra
  30. pip freeze without dependencies of installed packages

Leave a Comment