Failed building wheel for mysql-python

by

Edit

Please try installing the .whl file from http://www.lfd.uci.edu/~gohlke/pythonlibs/. This works every time. Just type pip install MySQL_python‑1.2.5‑cp27‑none‑win32.whl in the terminal.

Original Answer

I had the same issue. You might find these steps helpful.

  1. Make sure you are in an activated virtualenv when you are installing anything through pip.
  2. Before you install anything, type pip list in the terminal to see what you have installed in the virtualenv. It should have wheel, setuptools and pip.
  3. This is the part that helped me, type pip install mysqlclient==1.3.9 or whatever version you want to install. This needs to happen before you install django.
  4. Hopefully, it works and you can go ahead and install Django.

If these steps didn’t work out for you, try installing MySQL-Python through the executable file here https://pypi.python.org/pypi/MySQL-python/1.2.5.

But this will only install mysql-python for you in the system. You can try pip list outside virtualenv to see if mysql-python is installed. If it is installed, then you have update this post so we can figure out a solution.

In the meantime some other fixes are:

  • Can’t install mysql-python (newer versions) in Windows
  • Install Visual C++ for Python and add the bin folder to the PATH environment variable.
  • Make sure the mysql service is running in the background or is installed in your system by running mysql commands through the terminal.
  • Sometimes, two different instances of mysql service might cause this error i.e. if you have installed mysql server or any other product multiple times in the past, you might have to get rid of the ports the past services used. In this case, do a fresh installation of mysql server and add the ~\bin path to the PATH environment variable.

More Related Contents:

  1. Why MYSQL IN keyword not considering NULL values
  2. Error installing mysqlclient for python on Ubuntu 18.04
  3. Should I use the datetime or timestamp data type in MySQL?
  4. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  5. MySQL string replace
  6. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  7. How do I get the current time zone of MySQL?
  8. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  9. MySQL select one column DISTINCT, with corresponding other columns
  10. Mysql Convert Column to row (Pivot table )
  11. Writing optional parameters within stored procedures in MySQL? [duplicate]
  12. How to get all columns’ names for all the tables in MySQL?
  13. How do I get MySQL to use an INDEX for view query?
  14. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  15. Restore the mysql database from .frm files
  16. Mysql insert random datetime in a given datetime range
  17. Greatest value of multiple columns with column name?
  18. insert data from one table to another in mysql
  19. MySQL UPDATE syntax with multiple tables using WHERE clause
  20. MySQL load data infile – acceleration?
  21. How to close sqlalchemy connection in MySQL
  22. How do I lock on an InnoDB row that doesn’t exist yet?
  23. MySQL Fulltext Search Score Explained
  24. Duplicate / Copy records in the same MySQL table
  25. mysql error: Table “mysql”.”innodb_table_stats” not found
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. How can I decrypt MySQL passwords
  28. MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields
  29. Does MySQL support historical date (like 1200)?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment