[Django]-Error configuring django with python-mysql in Mac OS 10.6.6

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH

or:

pip install MySQL-python
pip install --upgrade MySQL-python

Helped me within a virtualenv

I had a similar problem, which I solved for the development program by including this line in my .bash_profile file (the magic file in my ~ directory which runs the shell):
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/
where the offending libmysqlclient.16.dylib is in that directory.

However, when I try to run this within Apache as a python wsgi module Apache cannot find the libmysqlclient.16.dylib no matter what I do. I have tried
sys.path.append(‘/usr/local/mysql/lib’)
os.environ[‘DYLD_LIBRARY_PATH’] = ‘/usr/local/mysql/lib’
no luck…
seems Apache does not read this environment variable, nor does python in this context (where it is not reading my .bash_profile file)… help!!!

Try:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.mysql',

Instead of just mysql, if you’re running Django 1.2.5.