Installing MySQL for python/Django

Question

I'm trying to use MySQL with django and right now the following isn't executing properly:

python manage.py syncdb

I also downloaded the Mysql-python interpreter and ran the following lines but still an error:

python setup.py build
sudo python setup.py install


Traceback (most recent call last):
  File "setup.py", line 15, in <module>
    metadata, options = get_config()
  File "/Users/user/Downloads/MySQL-python-1.2.3/setup_posix.py", line 49, in get_config
    libs = mysql_config("libs")
  File "/Users/user/Downloads/MySQL-python-1.2.3/setup_posix.py", line 24, in mysql_config
    raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: /usr/local/bin/mysql_config not found

I think it's having trouble finding mysql_config, is there a way that I can point the setup to the file? Right now my setup.py is in ~/Downloads and mysql is in /usr/local/mysql/bin

So... does /usr/local/bin/mysql_config exist? If not, you need to tell it where mysql_config is. — agf
– agf, Commented Aug 2, 2011 at 19:30
no it doesn't exist, but I don't know where to find it or tell the system where to find it. — locoboy
– locoboy, Commented Aug 2, 2011 at 20:04
Please clarify what operating system you are running on and what version of Python you are trying to use. Otherwise, we will just be guessing at how to help. — Ned Deily
– Ned Deily, Commented Aug 2, 2011 at 20:20

nesv · Accepted Answer · 2011-08-02 19:42:11Z

2

It seems you may not have any of the MySQL client applications installed. If you are using Linux (and this varies from distribution to distribution), the package you will need to install on Ubuntu is "mysql-client".

answered Aug 2, 2011 at 19:42

nesv

8127 silver badges10 bronze badges

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

1 Comment

mdeous Over a year ago

the MySQL headers will be also required to compile the module, the package name should be mysql-dev or something similar.

Community · Accepted Answer · 2017-05-23 12:11:56Z

1

From the path you show, I'm guessing you are running on Mac OS X (you really need to state what platform you are using and what version of Python you are running). However, if you are on Mac OS X, your best bet by far is to use a complete solution of installing compatible versions of Python, MySQL client libraries, MySQLdb, and Django by using one of the third-party open source package managers on OS X: MacPorts, homebrew, Fink, or others.

See, for example, the answer here.

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Aug 2, 2011 at 20:14

Ned Deily

85.4k17 gold badges134 silver badges156 bronze badges

1 Comment

locoboy Over a year ago

I am using all the right versions, but I think the main issue is that my install of mysql-python can't find the mysql_config file. Does this have something to do with where I'm running the build script? Right now the mysql-python folder is in ~/Downloads and mysql_config is in /usr/local/mysql/bin/

locoboy · Accepted Answer · 2011-08-05 08:26:13Z

0

The answer was to edit the site.cfg file so that it points to the mysql_config file in the /usr/local/mysql dir

answered Aug 5, 2011 at 8:26

locoboy

39.1k73 gold badges190 silver badges263 bronze badges

Collectives™ on Stack Overflow

Installing MySQL for python/Django

3 Answers 3

1 Comment

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Linked

Related