What package should I use to query Mysql Databases in Python?

Question

I need to query a Mysql database with Python.

I have virtual env installed and also PIP, I have tried to install this package, http://pypi.python.org/pypi/MySQL-python/#downloads but without success.

I have parformed the command:

sudo pip install http://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.3.tar.gz#md5=215eddb6d853f6f4be5b4afc4154292f

And I have got the error:

(python_virtualenv)andre@ubuntu:~/workspace/RS_r/src$ sudo pip install http://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.3.tar.gz#md5=215eddb6d853f6f4be5b4afc4154292f
[sudo] password for andre: 
Downloading/unpacking http://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.3.tar.gz#md5=215eddb6d853f6f4be5b4afc4154292f
  Downloading MySQL-python-1.2.3.tar.gz (70Kb): 70Kb downloaded
  Running setup.py egg_info for package from http://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.3.tar.gz#md5=215eddb6d853f6f4be5b4afc4154292f
    sh: mysql_config: not found
    Traceback (most recent call last):
      File "<string>", line 14, in <module>
      File "/tmp/pip-l0kPkg-build/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 "/tmp/pip-l0kPkg-build/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
Storing complete log in /home/andre/.pip/pip.log

My questions. What package should I install to query Mysql databases and how should I install? Pip install should be used in this case?

Give me a clue.

Best regards,

score 4 · Accepted Answer · answered May 19 '11 at 11:51

4

The error message is self-speaking

sh: mysql_config: not found

mysql_config is part of the MySQL installation is either not installed nor not available from the $PATH. This is the problem to be solved - not the question about binding alternatives.

answered May 19 '11 at 11:51

Plus, if he'd googled the error message, he would have found a bunch of pages giving the solution. – Daniel Roseman May 19 '11 at 12:09

score 1 · Answer 2 · edited May 23 '17 at 12:26

1

Have a look at this links: one, two, three The source you can find here

edited May 23 '17 at 12:26

Community

1
1

answered May 19 '11 at 11:56

nikagra

835
2
9
23

unutbu · Answer 3 · 2011-05-19T12:18:31.930

The error message shows you are missing mysql_config (and seem to be on an Ubuntu machine):

EnvironmentError: mysql_config not found
...
sh: mysql_config: not found

dpkg -S can show which package provides mysql_config -- assuming you have a machine with mysql_config installed... :)

% dpkg -S $(which mysql_config)
libmysqlclient-dev: /usr/bin/mysql_config

Therefore, it looks like you need to install the libmysqlclient-dev package.

PS. If you don't have a machine with mysql_config installed, the same info can be found at http://packages.ubuntu.com/.

What package should I use to query Mysql Databases in Python?

3 Answers3