unable to install mysqlclient on mac

Question

I'm attempting to install mysqlclient using the command:

pip install mysqlclient but i get the following error:

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/8d/xdwdnphs1w5b_vtxrc67__5h0000gn/T/pip-build-ifu54299/mysqlclient/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "/private/var/folders/8d/xdwdnphs1w5b_vtxrc67__5h0000gn/T/pip-build-ifu54299/mysqlclient/setup_posix.py", line 44, in get_config
        libs = mysql_config("libs_r")
      File "/private/var/folders/8d/xdwdnphs1w5b_vtxrc67__5h0000gn/T/pip-build-ifu54299/mysqlclient/setup_posix.py", line 26, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    OSError: mysql_config not found

I uninstalled python3 using brew uninstall --force python3 and downloaded the binary from pythons website but to no avail. I also attempted to download mysql connector from oracle website and again to no avail. I have tried upgrading pip again still doesnt work.

PS mysql is running in a docker container and i'm running django on my local machine.

Any suggestions on why i'm getting an error attempting to install mysqlclient

Have you installed MySQL? If so, check whether `mysql_config` is in `$PATH`, and if not, add it. — Adrijaned, Oct 03 '17 at 07:57
@Adrijaned i didnt install mysql. I'm running mysql in a docker container. — EI-01, Oct 03 '17 at 16:31

Zrufy · Answer 1 · 2017-10-03T07:50:22.500

0

For Python I can recommend pymysql is pretty good and I always use it. https://github.com/PyMySQL/PyMySQL

or you can follow this answer

Installing MySQL Python on Mac OS X

edited Oct 03 '17 at 07:50

answered Oct 03 '17 at 07:30

Zrufy

423
9
22

what would be the mistake it gives you? If you can not connect to the database. Just add where the mysqli.sock file is located. For example: `conn = pymysql.connect(db='DB', user='USER', passwd='pass', unix_socket="/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock",autocommit=True)` Let me know news. – Zrufy Oct 21 '17 at 15:13

Chamath Rathnayake · Answer 2 · 2020-05-17T23:02:15.653

0

you need to install mysql and mysql connector before install my sql client

brew install mysql

brew install mysql-connector-c

edited May 17 '20 at 23:02

answered Feb 02 '20 at 19:09

Chamath Rathnayake

34
3

unable to install mysqlclient on mac

2 Answers2