Install MySQL-python

Question

I got a failure while trying to install MySQL-python on my Ubuntu / Linux Box. From below, it looks like the problem is: sh: mysql_config: not found Can someone advise me 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 

Answer 1

Ubuntu recommends using the distribution repository. Therefore, the installation of python-mysqldb should be direct:

 sudo apt-get install python-mysqldb 

If you really want to use pip to install, as mentioned earlier, and not the suggested path, but maybe please look at this previously asked question and answer: pip install mysql -python does not work with EnvironmentError: mysql_config not found

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

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

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

Answer 2

You have 2 options, as described below:

---

A distribution package such as Glaslos suggested:

 # sudo apt-get install python-mysqldb 

In this case, you cannot use virtualenv no-site-packages (the default option) but you must use:

 # virtualenv --system-site-packages myenv 

---

Use pure virtualenv and create your own python-mysql package.

First create virtualenv:

 # virtualenv myvirtualenv # source myvirtualenv/bin/activate 

Then install the 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 )

Answer 3

 yum install mysql-devel 

It worked for me.

Answer 4

Reread the error message. It says:

sh: mysql_config: not found

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

Answer 5

• find the folder: sudo find / -name "mysql_config" (suppose that "/opt/local/lib/mysql5/bin" )

• add it to PATH: export PATH:export PATH=/opt/local/lib/mysql5/bin:$PATH

• install it again

Answer 6

Python or Python3 with MySQL, you will need these. These libraries use the MySQL connector for C and Python (you also need the C libraries), which remove 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 

Answer 7

this worked for me in python 3

pip install mysqlclient