MYSQL- python pip install error

Question

I tried to get build an app on Django and I wanted to use MySQL as the database. After setting up the settings.py right, I tried to migrate. Then I got the obvious error saying that MySQL is not installed. So inorder to install MySQL, I ran:

sudo -H pip install MySQL-python

I get the following error:

    Collecting MySQL-python
  Using cached MySQL-python-1.2.5.zip
    Complete output from command python setup.py egg_info:
    sh: mysql_config: command not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/private/tmp/pip-build-zAMhWo/MySQL-python/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 43, in get_config
        libs = mysql_config("libs_r")
      File "setup_posix.py", line 25, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: mysql_config not found

    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /private/tmp/pip-build-zAMhWo/MySQL-python/

How do I fix this?

Possible duplicate of mysql_config not found when installing mysqldb python interface — GoingMyWay
– GoingMyWay, Commented Feb 21, 2017 at 3:05

McGrady · Accepted Answer · 2017-02-21 03:22:49Z

13

MySQL-python

MySQL-3.23 through 5.5 and Python-2.4 through 2.7 are currently supported. Python-3.0 will be supported in a future release.

You can install mysqlclient or pymysql,I prefer the latter:

pip install pymysql

And add this to your manage.py:

import pymysql
pymysql.install_as_MySQLdb()

edited Feb 21, 2017 at 3:22

answered Feb 21, 2017 at 3:04

McGrady

11.5k14 gold badges54 silver badges70 bronze badges

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

4 Comments

JGCW Over a year ago

sudo and your command worked. But I cannot still run python manage.py migrate.

McGrady Over a year ago

@GeethW add this to your manage.py,import pymysql pymysql.install_as_MySQLdb()

JGCW Over a year ago

Thank you so much McGrady. I don't really understand what happened. Can you explain? I tried so many driver options. For example, pip install mysql-python and then manually downloading a .dmg from oracle. Nothing worked. Please explain.

McGrady Over a year ago

@GeethW Actually,I can't explain what happened when you install mysql-python, it seems that pymysql is more friendly than mysql-python to support python now.

Vic · Accepted Answer · 2019-05-31 13:43:07Z

6

Did you install the SQL client dev pacakge on your system?

sudo apt install libmysqlclient-dev

if you are using mariadb, the drop in replacement for mysql, then run

sudo apt install libmariadbclient-dev

then try again

pip install mysql-connector

edited May 31, 2019 at 13:43

answered May 31, 2019 at 13:23

Vic

1611 silver badge4 bronze badges

Comments

Prashant Jamkhande · Accepted Answer · 2019-05-20 07:14:08Z

2

Installations of mysql in some environments can place binaries in directory relative to environment. pip installation fails because setup.py does not find mysql_config at expected path. Steps for source installation -

Download files here Edit mysql_config path mentioned in MySQL-python-1.2.5/site.cfg with correct path on your local environment. For example,

mysql_config = /usr/local/mysql/bin/mysql_config

Run below commands inside directory MySQL-python-1.2.5 -

$ python setup.py build
$ sudo python setup.py install

answered May 20, 2019 at 7:14

Prashant Jamkhande

1361 silver badge12 bronze badges

Comments

Rob Grossman · Accepted Answer · 2017-02-21 03:05:32Z

1

Have you tried installing a MySQL db driver?

The following documentation tells you how to install one:

https://docs.djangoproject.com/en/1.10/ref/databases/#mysql-db-api-drivers

answered Feb 21, 2017 at 3:05

Rob Grossman

1,47013 silver badges22 bronze badges

Comments

Elalami Mehdi · Accepted Answer · 2017-10-07 09:46:22Z

1

I faced the same problem trying to install mysqlclient, try to install mysql-devel. on RHEL/Centos for example:

yum install mysql-devel

answered Oct 7, 2017 at 9:46

Elalami Mehdi

112 bronze badges

Comments

Deepanshu Mehta · Accepted Answer · 2024-07-06 13:52:20Z

1

for windows use: pip install mysql-connector-python

answered Jul 6, 2024 at 13:52

Deepanshu Mehta

1,84817 silver badges15 bronze badges

Collectives™ on Stack Overflow

MYSQL- python pip install error

6 Answers 6

4 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

4 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related