python setup.py egg_info error mysqlclient

Question

I just started learning Python using Django and I just seemed to be stuck at the same place for 3 days, every time I try to run the following command in my terminal using Pycharm (Yep, I am using a Mac) I get the below error:

Command: pip install mysqlclient

Error:

Collecting mysqlclient
Using cached mysqlclient-1.3.12.tar.gz
Complete output from command python setup.py egg_info:
/bin/sh: mysql_config: command not found
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-c7mudszc/mysqlclient/setup.py", line 17, in <module>
metadata, options = get_config()
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-c7mudszc/mysqlclient/setup_posix.py", line 44, in get_config
(venv) Mervins-MacBook-Pro:untitled mervinkobola$ pip install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-1.3.12.tar.gz
Complete output from command python setup.py egg_info:
/bin/sh: mysql_config: command not found
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-w_jamo3b/mysqlclient/setup.py", line 17, in <module>
metadata, options = get_config()
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-w_jamo3b/mysqlclient/setup_posix.py", line 44, in get_config
(venv) Mervins-MacBook-Pro:untitled mervinkobola$ pip install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-1.3.12.tar.gz
Complete output from command python setup.py egg_info:
/bin/sh: mysql_config: command not found
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-xefx4qk7/mysqlclient/setup.py", line 17, in <module>
metadata, options = get_config()
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-xefx4qk7/mysqlclient/setup_posix.py", line 44, in get_config
libs = mysql_config("libs_r")
File "/private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-xefx4qk7/mysqlclient/setup_posix.py", line 26, in mysql_config
raise EnvironmentError("%s not found" % (mysql_config.path,))
OSError: mysql_config not found

----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/3z/_xzmzzh90z9dj90cb70p3q0c0000gn/T/pip-build-xefx4qk7/mysqlclient/

Please help me understand whats going on and how I can solve it. Above all I can't seem to run the following :

python manage.py migrate (as I haven't installed mysqlclient)

Thank you in advance for your assistance.

You might find this answer useful (ignore the pip install MySQL-Python and stick with pip install mysqlclient). Note that if you're just learning Python and Django, you may find it easier to stick with sqlite3 instead of MySQL. — Alasdair
– Alasdair, Commented Jan 23, 2018 at 13:00
Thank you for your response, well I've already used MySQL, and it seems to connecting successfully, I just cant run the following command "python manage.py migrate" for my tables, it will ask me if I've installed mysqlclient (even when I go to my virtual env and try there without using my command, it still gives an error), is there pehaps a quick fix, and this is on mac using pycharm? — Mervink
– Mervink, Commented Jan 23, 2018 at 13:09
The quickest fix is to use sqlite3, which doesn't require any additional packages to be installed. If you want to use Django with MySQL, then you need to install mysqlclient in your virtual environment. The answer I linked to has some suggestions for installing it on a Mac which will hopefully help, but I'm afraid I don't have any other suggestions. — Alasdair
– Alasdair, Commented Jan 23, 2018 at 13:28
Thank you very much, I will use mysqlite 3, hopefully this will help. — Mervink
– Mervink, Commented Jan 23, 2018 at 13:31

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

Sometimes the variable mysql_config is set in the Terminal but not in PyCharm so this is why you're getting this error.

The solution is:

run the PyCharm from the terminal with this command:

/Applications/PyCharm\ CE.app/Contents/MacOS/pycharm
After that (in PyCharm) install the packages you need (probably they are in your requirements.txt, for example the mysqlclient),
Close the program and re-open
Now it should have all the packages installed properly

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 17, 2019 at 0:17

octaedro

6596 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

python setup.py egg_info error mysqlclient

1 Answer 1

The solution is:

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

The solution is:

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related