macos - python setup.py egg_info mysqlclient

Question

Trying to install mysqlclient using pip3 on Python 3.6.0

$ pip3 install mysqlclient
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/3k/08g3yx_12kg99kyfs989md600000gn/T/pip-build-1qv_89jc/mysqlclient/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "/private/var/folders/3k/08g3yx_12kg99kyfs989md600000gn/T/pip-build-1qv_89jc/mysqlclient/setup_posix.py", line 54, in get_config
        libraries = [dequote(i[2:]) for i in libs if i.startswith('-l')]
      File "/private/var/folders/3k/08g3yx_12kg99kyfs989md600000gn/T/pip-build-1qv_89jc/mysqlclient/setup_posix.py", line 54, in <listcomp>
        libraries = [dequote(i[2:]) for i in libs if i.startswith('-l')]
      File "/private/var/folders/3k/08g3yx_12kg99kyfs989md600000gn/T/pip-build-1qv_89jc/mysqlclient/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/3k/08g3yx_12kg99kyfs989md600000gn/T/pip-build-1qv_89jc/mysqlclient/

Already did

brew install mysql-connector-c

But still getting this error

Answer 1

This worked for me:

1. brew install mysql-connector-c

2. edit mysql_config (locate it: which mysql_config)

correct this in mysql_config:

# Create options 
libs="-L$pkglibdir"
libs="$libs -l "

It shoud be:

# Create options 
libs="-L$pkglibdir"
libs="$libs -lmysqlclient -lssl -lcrypto"

4. brew info openssl
5. and finally pip3 install mysqlclient

Answer 2

I resolved this installing libmysqlclient-dev first:

sudo apt-get install libmysqlclient-dev

Hope it works for you.

Answer 3

After extensive troubleshooting, I found that the brew install mysql-connector-c just does not work.

The problem stems from the system not being able to identify that mysql_config is installed (which is what mysql-connector-c essentially does). Homebrew's method (open for argument) of installing the mysql-connector-c in its /Cellar/ and creating a symlink to the /usr/local/bin/ directory seems to be causing problems as Python tries to follow the symlink.

To resolve the issue I performed the following:

1. brew uninstall mysql-connector-c
2. download/install MacOS X MySQL Connector/C from Oracle's MySQL site
   • note: just download the .dmg, no need to be complicated here...
3. restart MacOS Terminal (or iTerm2) for good measure

4. which mysql_config

   • you should see the correct path /usr/local/bin/mysql/bin/mysql_config

5. activate virtualenv (if applicable)

6. pip install mysqlclient

There may be other ways to still use Homebrew, but this was the most straightforward solution I found.

Note that the mysqlclient GitHub README.md also states that the C-developer headers for Python3 are needed. I assume that mysql-connector-c includes those; however, should you run into more issues, you might also install the Xcode Developer CI Tools for good measure.

xcode-select --install

They include the C compiler and other developer utilities from Apple. Read more here.

Answer 4

Came across this while developing a django-based website, and I needed to set up the website to communicate with a mysql database. I've not used homebrew to do any of my installations.

Since I'm doing the development on a MacOS with Anaconda installed, I discovered that there was an issue with Anaconda. Without knowing the details, I was able to install mysqlclient with conda install mysqlclient

Hope that helps someone else with this problem as well.

Answer 5

For Python 2.7 on specific programs:

1. sudo chown -R $USER /Library/Python/2.7
2. brew install [email protected]
3. brew install mysql-connector-c
4. brew link --overwrite [email protected]
5. echo 'export PATH="/usr/local/opt/[email protected]/bin:$PATH"' >> ~/.bash_profile
6. sed -i -e 's/libs="$libs -l "/libs="$libs -lmysqlclient -lssl -lcrypto"/g' /usr/local/bin/mysql_config
7. pip install MySql-python

This solved all issues I was having running a program that ran on Python 2.7 on and older version of MySql

Answer 6

Other options didn't work for me, but this worked for me:

For Python3:

env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip3 install mysqlclient

For Python2:

env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip2 install mysqlclient

or

env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip install mysqlclient

Answer 7

Personally I recommend using pymysql instead of using mysqlclient. You can install pymysql with:

pip install pymysql

And you might edit your SQLAlchemy URL to:

mysql+pymysql://username:passwd@hostname/database

Answer 8

I'm just getting started with python and had similar problems when trying to do pip3 install mysqlclient to connect Django to MySQL 8.0.19 but on my case it is on a macOS Catalina 10.15.5 with Python 3.8. I also tried brew install mysql-connector-c but it also gave me a lot of trouble. Here's how I manage to make it work.

1. brew reinstall mysql
2. brew install mysql-client

• Note: After installing mysql-client I got the following messages in the terminal which I just followed and got all to work.
• mysql-client is keg-only, which means it was not symlinked into /usr/local, because it conflicts with mysql (which contains client libraries). If you need to have mysql-client first in your PATH run:

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

• For compilers to find mysql-client you may need to set:

4. export LDFLAGS="-L/usr/local/opt/mysql-client/lib"
5. export CPPFLAGS="-I/usr/local/opt/mysql-client/include"

• Then I just tried to install mysqlclient again and it worked. I also tried it on a python .venv environment and it worked as well using:

6. pip3 install mysqlclient

References: Install mysqlclient for Django Python on Mac OS X Sierra

Hope this works as it did for me today. Regards, Alfredo

Answer 9

This worked for me on MacOS 10+. Rather than directly installing mysqlclient using pip, use this command first

brew install mysql

If you do not have an existing setup for brew, then install brew from it's homepage

Then run

pip install mysqlclient

This should work! Also ensure you have a virtualenv set up for your projects, as it is among good practices to maintain venv's for each project seperately.