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 to use MySQL with Django, but after installing the mysql connector, I tried to install mysqlclient for Python on $ pip install mysqlclient , but I have this problem:

 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/ 

Answer 1

I also ran into this problem, below is my step:

1. brew install mysql-connector-c

2. pip install mysqlclient

and then ran into this error, I traced the source code, but solved it, then another error occurred.

so I changed the installation method of mysqlclient simply:

1. brew install mysql

2. pip install mysqlclient

it worked for me, there were no errors.

Answer 2

I need 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 install mysqlclient pip wheel mysqlclient / pip install mysqlclient successfully pip install mysqlclient

Answer 3

Install mysql-client instead of mysql if you do not plan to have mysql on 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"

Answer 4

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

Run the following commands in the terminal,

 $ brew install mysql $ export PATH=$PATH:/Applications/MySQLWorkbench.app/Contents/MacOS $ xcode-select --install $ pip install mysqlclient 

Answer 5

Install mysql with 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 

Answer 6

 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 works perfectly