installing mysqldb wih django

Question

so i am trying to get mysql working with django but it requires mysqldb so i downloaded it and then tried to install by unzipping it but this raises an exception

python setup.py build
-----------------------
sh: mysql_config: command not found
Traceback (most recent call last):
 File "setup.py", line 15, in <module>
 metadata, options = get_config()
 File "/users/tushar/MySQL-python-1.2.3/setup_posix.py", line 43, in get_config
 libs = mysql_config("libs_r")
 File "/users/tushar/MySQL-python-1.2.3/setup_posix.py", line 24, in mysql_config
 raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found

could you all please help me as am not able to get rid of this exception

• Dan Goldsmith: You do have mysql installed ?
• Sam Starling: It's basically saying that the command mysql_config can't be found - either because you don't have MySQL installed, or because it's not in your path. What kind of computer are you on - Windows, Mac, Linux?
• Sridhar Ratnakumar: Have you tried the pre-build binary from code.activestate.com/pypm/mysql-python ?

Answer 1

If your OS is Ubuntu, try "sudo apt-get install python-mysqldb".

Though this might not put your mysqldb into your site-packages, if you prefer to have it there. I usually use this guide to install mysqldb: How to install MySQLdb in a virtualenv on Ubuntu Karmic. This works for virtualenv as well as for normal installation. In the last case simple use pip install MYSQL-python instead of pip install -E default/ MySQL-python.

Answer 2

If your OS is Ubuntu, try "sudo apt-get install python-mysqldb".

• Pierre de LESPINAY: Does Python need to be recompiled after that ?

Answer 3

That should do the trick:

1) sudo apt-get build-dep python-mysqldb

2) pip install MySQL-python

Worked like a charm for me when I have received the same error you have.

Answer 4

Install "-devel" package. What is missing is a development libraries and tools provided by mysql.

Another cause can be that devel-package (especially mysql_config program is not in your path).

Answer 5

The problem is that mysql_config is not found. In the site.cfg file (inside MySQL-python-1.2.3) you can see the following:

# The path to mysql_config.
# Only use this if mysql_config is not on your PATH, or you have some weird
# setup that requires it.
#mysql_config = /usr/local/bin/mysql_config

You need to have mysql server installed for installing the MySQL-python module. If you installed mysql server with the package manager, mysql_config should be in the path. If you have a mysql custom installation, you can either add the mysql bin directory to the path or uncomment the mysql-config line in the site.cfg file pointing to the right location.

Answer 6

To fix this, do

sudo PATH=/usr/local/mysql/bin/:$PATH pip install mysql-python

As mentioned in the previous answer, the site.cfg has a hint on what to do - it says to uncomment the path to mysql_config if it is not in your path - so just make sure it is in your path.

I did this and it worked..

---

15 warnings generated.
 clang -bundle -undefined dynamic_lookup -Wl,-F. build/temp.macosx-10.8-intel-2.7/_mysql.o -L/usr/local/mysql/lib -lmysqlclient_r -lz -lm -lmygcc -o build/lib.macosx-10.8-intel-2.7/_mysql.so -arch x86_64
Successfully installed mysql-python
Cleaning up...

---

Hope this helps.

Thanks.