Installing MySQL-python

Question

I got the below failure while trying to get MySQL-python installed on my Ubuntu/Linux Box.From the below it seem like the issue is sh: mysql_config: not found Could someone advice me on what to do?

rmicro@ubuntu:~$ pip install MySQL-python
Downloading/unpacking MySQL-python
  Downloading MySQL-python-1.2.3.tar.gz (70Kb): 70Kb downloaded
  Running setup.py egg_info for package MySQL-python
    sh: mysql_config: not found
    Traceback (most recent call last):
      File "<string>", line 14, in <module>
      File "/home/rmicro/build/MySQL-python/setup.py", line 15, 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 24, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: mysql_config not found
    Complete output from command python setup.py egg_info:
    sh: mysql_config: not found

Traceback (most recent call last):
  File "<string>", line 14, in <module>
  File "/home/rmicro/build/MySQL-python/setup.py", line 15, 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 24, 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

possible duplicate of [pip install mysql-python fails with EnvironmentError: mysql\_config not found](http://stackoverflow.com/questions/5178292/pip-install-mysql-python-fails-with-environmenterror-mysql-config-not-found) — Lukas Graf, Mar 14 '15 at 13:54

score 160 · Accepted Answer · edited May 23 '17 at 12:18

160

On Ubuntu it is advised to use the distributions repository. So installing python-mysqldb should be straight forward:

sudo apt-get install python-mysqldb

If you actually want to use pip to install, which is as mentioned before not the suggested path but possible, please have a look at this previously asked question and answer: pip install mysql-python fails with EnvironmentError: mysql_config not found

Here is a very comprehensive guide by the developer: http://mysql-python.blogspot.no/2012/11/is-mysqldb-hard-to-install.html

To get all the prerequisites for python-mysqld to install it using pip (which you will want to do if you are using virtualenv), run this:

sudo apt-get install build-essential python-dev libmysqlclient-dev

edited May 23 '17 at 12:18

Community

1
1

answered Sep 18 '11 at 13:03

Glaslos

2,872
1
21
31

1

Could explain what you really meant by that? – user618677 Sep 18 '11 at 14:15
I think he is saying that if you install python-mysqldb as a repository package, the system will handle dependency management for you, realizing that it needs to install libmysqlclient-dev too – ftartaggia Sep 18 '11 at 15:06
2

@user618677: `sudo apt-get install python-mysqldb` – jfs Sep 18 '11 at 17:03
Thank you all, it worked. It pretty obvious that I need to learn more of Ubuntu. – user618677 Sep 19 '11 at 10:21
1

@zalun as mentioned at the end of my answer if you want to use pip (in virtualenv) you have to install the prerequisites by hand. – Glaslos Jan 19 '13 at 12:49
i am in same problem but Mac OSX. How can i fix this issue? – hizbul25 Oct 22 '19 at 10:44

score 15 · Answer 2 · edited Jul 09 '13 at 03:02

You have 2 options, as described bellow:

Distribution package like Glaslos suggested:

# sudo apt-get install python-mysqldb

In this case you can't use virtualenv no-site-packages (default option) but must use:

# virtualenv --system-site-packages myenv

Use clean virtualenv and build your own python-mysql package.

First create virtualenv:

# virtualenv myvirtualenv
# source myvirtualenv/bin/activate

Then install build dependencies:

# sudo apt-get build-dep python-mysqldb

Now you can install python-mysql

# pip install mysql-python

NOTE Ubuntu package is python-mysql*db* , python pypi package is python-mysql (without db)

score 8 · Answer 3 · edited Sep 29 '15 at 21:48

8

yum install mysql-devel

It worked for me.

edited Sep 29 '15 at 21:48

samayo

16,163
12
91
106

answered Sep 03 '13 at 09:59

Mayank

5,411
1
16
16

score 7 · Answer 4 · answered Sep 18 '11 at 06:44

7

Reread the error message. It says:

sh: mysql_config: not found

If you are on Ubuntu Natty, mysql_config belongs to package libmysqlclient-dev

answered Sep 18 '11 at 06:44

gsbabil

7,505
3
26
28

score 3 · Answer 5 · answered Mar 23 '16 at 00:28

Python or Python3 with MySQL, you will need these. These libraries use MySQL's connector for C and Python (you need the C libraries installed as well), which overcome some of the limitations of the mysqldb libraries.

   sudo apt-get install libmysqlclient-dev
   sudo apt-get install python-mysql.connector
   sudo apt-get install python3-mysql.connector

score 1 · Answer 6 · answered Jun 26 '17 at 14:27

1

this worked for me on python 3

pip install mysqlclient

answered Jun 26 '17 at 14:27

Jouhayna

19
1

score 1 · Answer 7 · edited Sep 29 '15 at 21:49

1

find the folder: sudo find / -name "mysql_config" (assume it's "/opt/local/lib/mysql5/bin")
add it into PATH:export PATH:export PATH=/opt/local/lib/mysql5/bin:$PATH
install it again

edited Sep 29 '15 at 21:49

samayo

16,163
12
91
106

answered Dec 05 '11 at 06:30

xiecheng127

119
1

score 0 · Answer 8 · answered Mar 21 '20 at 04:48

0

In python3 with virtualenv on a Ubuntu Bionic machine the following commands worked for me:

sudo apt install build-essential python-dev libmysqlclient-dev
sudo apt-get install libssl-dev
pip install mysqlclient

answered Mar 21 '20 at 04:48

nsssayom

364
1
5
21

Installing MySQL-python

8 Answers8

pip install mysqlclient

Linked