Install mysqlclient for Django Python on Mac OS X Sierra

Question

I have already installed

Python 2.7.13
Django 1.11
MySQL 5.7.17

I want use MySQL with Django, but after install mysql connector I was try to install mysqlclient for Python on $ pip install mysqlclient, but I have this issue:

Collecting mysqlclient
  Using cached mysqlclient-1.3.10.tar.gz
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/private/var/folders/y_/c31n_1v12v169zfv829p_v_80000gn/T/pip-build-f51KhW/mysqlclient/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 54, in get_config
        libraries = [dequote(i[2:]) for i in libs if i.startswith('-l')]
      File "setup_posix.py", line 12, in dequote
        if s[0] in "\"'" and s[0] == s[-1]:
    IndexError: string index out of range

    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/y_/c31n_1v12v169zfv829p_v_80000gn/T/pip-build-f51KhW/mysqlclient/

Had the same problem, and this approach worked: stackoverflow.com/questions/43740481/… — chadgates
– chadgates, Commented Jun 13, 2017 at 21:29

anthony sottile · Accepted Answer · 2019-02-21 03:36:36Z

56

I needed the following to build / install mysqlclient

brew install mysql-client
# mysql-client is not on the `PATH` by default
export PATH="/usr/local/opt/mysql-client/bin:$PATH"
# openssl is not on the link path by default
export LIBRARY_PATH="$LIBRARY_PATH:/usr/local/opt/openssl/lib/"

Then I could pip wheel mysqlclient / pip install mysqlclient successfully

edited Feb 21, 2019 at 3:36

answered Feb 4, 2019 at 17:22

anthony sottile

72k19 gold badges198 silver badges247 bronze badges

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

Comments

parik · Accepted Answer · 2017-09-22 16:39:47Z

27

I have encountered this problem too，below is my step：

1.brew install mysql-connector-c

2.pip install mysqlclient

and then encountered this error,i have Traced the source code，but solved this one then the other error occured.

so i changed the way to install mysqlclient,just :

1.brew install mysql

2.pip install mysqlclient

this worked for me,no any errors occured.

edited Sep 22, 2017 at 16:39

parik

2,41614 gold badges43 silver badges70 bronze badges

answered May 10, 2017 at 10:59

Neal Lee

2792 silver badges2 bronze badges

2 Comments

Zaira Zafar Over a year ago

this approach doesn't work for me. Can you suggest something else?

Ben Daggers Over a year ago

after morethan 2 hours of searching and trying to figure out how to make mysqlclient installation work, i am tired and hopelessly tried your solution... and voila! it worked! Thank you!!!

Community · Accepted Answer · 2019-04-25 11:42:07Z

16

Install mysql-client instead of mysql if you don't plan to have mysql in your computer

brew install mysql-client

echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile

source ~/.bash_profile

pip install mysqlclient

export LDFLAGS="-L/usr/local/opt/openssl/lib"

export CPPFLAGS="-I/usr/local/opt/openssl/include"

edited Apr 25, 2019 at 11:42

CommunityBot

11 silver badge

answered Jul 12, 2018 at 22:14

edilio

1,87815 silver badges13 bronze badges

2 Comments

tsmets Over a year ago

Last command failed on my Mac with a massive stacktrace, starting with : [code]Building wheels for collected packages: mysqlclient Building wheel for mysqlclient (setup.py) ... error Complete output from command /Users/tsmets/Documents/work/Projects/ISO27001RiskAssessment/site/venv/bin/python3.7 -u -c "import setuptools, tokenize;__file__='/private/var/folders/9l/ffh99l291kb9d_1_9mz3sq080000gn/T/pip-install-efrwnshd/mysqlclient/setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec... [/code]

linehrr Over a year ago

run those exports first. you will get it working. @tsmets

Alfredo Rodriguez · Accepted Answer · 2020-06-24 06:28:50Z

13

brew install/upgrade/reinstall mysql
brew install mysql-client
export PATH="/usr/local/opt/openssl/bin:$PATH"
export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"
pip install mysqlclient
works perfectly

edited Jun 24, 2020 at 6:28

Alfredo Rodriguez

1,2231 gold badge13 silver badges12 bronze badges

answered Jun 17, 2019 at 15:09

elhay efrat

1671 silver badge4 bronze badges

3 Comments

Nanhydrin Over a year ago

Please edit your answer to include some information on how it answers the question. This will make your answer more understandable and useful to the original poster and to future visitors. Thank you.

Saurabh Shrivastava Over a year ago

I am using mac and tried everything available on internet for 2 days and nothing worked except your solution. Thanks a lot.

Alfredo Rodriguez Over a year ago

I can confirm this worked for macOS Catalina 10.15.5, Python 3.8, Django 3.0.7 and mysql 8.0.19. Thank you!

gautamyadav · Accepted Answer · 2018-08-27 17:31:34Z

7

For Mac: first download Xcode from App Store and MySqlWorkbench from https://dev.mysql.com/downloads/workbench/

Run the following commands in terminal,

$ brew install mysql

$ export PATH=$PATH:/Applications/MySQLWorkbench.app/Contents/MacOS

$ xcode-select --install

$ pip install mysqlclient

edited Aug 27, 2018 at 17:31

answered Oct 8, 2017 at 9:42

gautamyadav

711 silver badge6 bronze badges

2 Comments

CarmenA Over a year ago

this is the only thing that worked for me, and I think most importantly is using "brew install mysql" cause with "brew install mysql-connector-c" I get same error from the question.

vee Over a year ago

this should be the answer

Julian Maya · Accepted Answer · 2018-03-23 04:57:32Z

3

Install mysql using brew and add it to the path:

$ brew install mysql

$ export PATH=/usr/local/mysql/bin:$PATH

$ sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/lib/libmysqlclient.18.dylib

$ pip install mysqlclient

answered Mar 23, 2018 at 4:57

Julian Maya

913 bronze badges

Comments

Simon Willison · Accepted Answer · 2021-06-11 19:01:47Z

2

This worked for me today, after using brew install mysql to install the MySQL server using Homebrew:

MYSQLCLIENT_CFLAGS=`pkg-config mysqlclient --cflags` \
  MYSQLCLIENT_LDFLAGS=`pkg-config mysqlclient --libs` \
  pip install mysqlclient

answered Jun 11, 2021 at 19:01

Simon Willison

15.9k6 gold badges41 silver badges46 bronze badges

1 Comment

sashaegorov Over a year ago

That worked for me, thank you. It seems this is the only relevant solution in 2022

Christopher Nolan · Accepted Answer · 2022-05-20 02:17:10Z

1

For my mac os, I need not to specify the path because brew do that for you. I just did below commands,

brew install mysql
brew install mysql-client
pip3 install mysqlclient

Everything is perfect & fine.

answered May 20, 2022 at 2:17

Christopher Nolan

1,1071 gold badge14 silver badges18 bronze badges

Comments

Archie · Accepted Answer · 2022-11-24 11:26:42Z

0

MAC M1 run

xcode-select --install

then run

pip install mysqlclient

answered Nov 24, 2022 at 11:26

Archie

214 bronze badges

Comments

Phistrom · Accepted Answer · 2023-06-28 21:33:30Z

brew info mysql-client might be the most future-proof way to find out what variables you need to set before you can install the mysqlclient package.

None of the answers here worked for me. After running brew install mysql-client, I then tried brew info mysql-client. The relevant section of its output was:

==> Caveats
mysql-client is keg-only, which means it was not symlinked into /opt/homebrew,
because it conflicts with mysql (which contains client libraries).

If you need to have mysql-client first in your PATH, run:
  echo 'export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql-client you may need to set:
  export LDFLAGS="-L/opt/homebrew/opt/mysql-client/lib"
  export CPPFLAGS="-I/opt/homebrew/opt/mysql-client/include"

For pkg-config to find mysql-client you may need to set:
  export PKG_CONFIG_PATH="/opt/homebrew/opt/mysql-client/lib/pkgconfig"

After running the exports described above, pip install mysqlclient worked.

eageranalyst · Accepted Answer · 2023-11-16 02:31:16Z

0

The flags were slightly different for me

brew install mysql
export MYSQLCLIENT_CFLAGS="-I/opt/homebrew/opt/mysql/include/mysql"
export MYSQLCLIENT_LDFLAGS="-L/opt/homebrew/opt/mysql/lib"   
pip install mysqlclient

answered Nov 16, 2023 at 2:31

eageranalyst

1,0269 silver badges15 bronze badges

Collectives™ on Stack Overflow

Install mysqlclient for Django Python on Mac OS X Sierra

11 Answers 11

Comments

2 Comments

2 Comments

3 Comments

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

11 Answers 11

Comments

2 Comments

2 Comments

3 Comments

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Linked

Related