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

kvasnicaj · Accepted Answer · 2018-01-16 13:54:37Z

48

This worked for me:

brew install mysql-connector-c
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"

brew info openssl
and finally pip3 install mysqlclient

answered Jan 16, 2018 at 13:54

kvasnicaj

6029 silver badges11 bronze badges

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

5 Comments

cmcromance Over a year ago

Works like a charm!! The Best solution, I think!! Thank you so much!!

kvasnicaj Over a year ago

You should change permissions or edit it with Vim and use wq! for saving changes

kvasnicaj Over a year ago

Do you have open ssl library? Try brew install openssl

РАВИ Over a year ago

for python 2.7 you don't need cypto. SSL will do the client. Also, add to set this the installation to read ssl: export LDFLAGS="-L/usr/local/opt/openssl/lib" (you can find this info by running brew info openssl as mentioned).

Marius Over a year ago

For my comprehension, what does the 4. point (brew info openssl) is it necessary ?

yosbel · Accepted Answer · 2017-05-23 17:42:17Z

25

I resolved this installing libmysqlclient-dev first:

sudo apt-get install libmysqlclient-dev

Hope it works for you.

answered May 23, 2017 at 17:42

yosbel

1,8514 gold badges23 silver badges34 bronze badges

4 Comments

BSathvik Over a year ago

The OP mentions "OSX"

yosbel Over a year ago

@FranklinAntony Sorry, it fixed to me the same error on Linux, but for Mac it would be: brew install mysql see this link: stackoverflow.com/questions/1857861/…

Terry Lin Over a year ago

Thanks. Your answer fixs the issue I met on Ubuntu 22.04 too.

user1207289 Mar 6 at 17:05

brew install mysql and then pip install mysqlclient solved for me

Israel Flores · Accepted Answer · 2017-06-02 22:36:18Z

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:

brew uninstall mysql-connector-c
download/install MacOS X MySQL Connector/C from Oracle's MySQL site
- note: just download the .dmg, no need to be complicated here...
restart MacOS Terminal (or iTerm2) for good measure
which mysql_config
- you should see the correct path /usr/local/bin/mysql/bin/mysql_config
activate virtualenv (if applicable)
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.

andrewec · Accepted Answer · 2018-06-07 06:45:06Z

1

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.

answered Jun 7, 2018 at 6:45

andrewec

13611 bronze badges

Comments

Ooguro · Accepted Answer · 2019-10-12 23:18:15Z

1

For Python 2.7 on specific programs:

sudo chown -R $USER /Library/Python/2.7
brew install [email protected]
brew install mysql-connector-c
brew link --overwrite [email protected]
echo 'export PATH="/usr/local/opt/[email protected]/bin:$PATH"' >> ~/.bash_profile
sed -i -e 's/libs="$libs -l "/libs="$libs -lmysqlclient -lssl -lcrypto"/g' /usr/local/bin/mysql_config
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

edited Oct 12, 2019 at 23:18

answered Oct 12, 2019 at 22:48

Ooguro

1212 silver badges14 bronze badges

Comments

girishsaraf03 · Accepted Answer · 2020-07-10 09:58:17Z

1

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.

answered Jul 10, 2020 at 9:58

girishsaraf03

1094 bronze badges

Comments

Sergei Kuznetcov · Accepted Answer · 2019-07-17 16:56:54Z

0

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

answered Jul 17, 2019 at 16:56

Sergei Kuznetcov

1652 silver badges7 bronze badges

Comments

Justin Lee · Accepted Answer · 2019-10-05 07:14:47Z

0

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

answered Oct 5, 2019 at 7:14

Justin Lee

8901 gold badge14 silver badges22 bronze badges

Comments

Alfredo Rodriguez · Accepted Answer · 2020-06-24 02:58:04Z

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.

brew reinstall mysql
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:

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

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

export LDFLAGS="-L/usr/local/opt/mysql-client/lib"
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:

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

egvo · Accepted Answer · 2023-01-30 12:26:38Z

For those who have similar error while trying to build python:<version>-alpine docker image, here is the solution:

FROM python:3.10-alpine

<...>

RUN apk update \
    && apk add --virtual build-deps gcc python3-dev musl-dev \
    && apk add --no-cache mariadb-dev

RUN python -m pip install mysqlclient==2.1.1

Details

If fact, it is similar to @yosbel's answer. But his answer is for debian-like linux systems (e.g. Ubuntu).

Error message I got with alpine image is below:

Collecting mysqlclient==2.1.1
Downloading mysqlclient-2.1.1.tar.gz (88 kB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 88.1/88.1 kB 6.8 MB/s eta 0:00:00
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status 'error'
error: subprocess-exited-with-error

× python setup.py egg_info did not run successfully.

<...>

note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

Collectives™ on Stack Overflow

python setup.py egg_info mysqlclient

10 Answers 10

5 Comments

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Details

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

5 Comments

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Details

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related