Problem setting up MySQL with python on OSX 10.6

Question

I'm trying to install MySQL on OSX 10.6 to work with Django.

MySQL seems to have installed correctly.

I'm attempting to install MySQLdb for Python I've tried using easy_install

$ python setup.py install

Which completes

But I'm getting the follow error:

Python 2.7.2 (v2.7.2:8527427914a2, Jun 11 2011, 15:22:34) 
[GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "MySQLdb/__init__.py", line 19, in <module>
    import _mysql
  File "build/bdist.macosx-10.6-intel/egg/_mysql.py", line 7, in <module>
  File "build/bdist.macosx-10.6-intel/egg/_mysql.py", line 6, in __bootstrap__
ImportError: dlopen(/Users/alanquigley/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-intel.egg-tmp/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib
  Referenced from: /Users/alanquigley/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-intel.egg-tmp/_mysql.so
  Reason: image not found
>>>

Any ideas?

related: http://stackoverflow.com/questions/4011500/installing-mysqldb-on-snow-leopard — Eric Wilson, Jul 05 '11 at 16:56

score 0 · Answer 1 · answered Jul 05 '11 at 17:12

0

Check to make sure the mysql client library (the C client library) is properly installed. Look in /usr/include or /usr/local/include for for a folder called "mysql". Do the same for /usr/lib or /usr/local/lib.

answered Jul 05 '11 at 17:12

Zhehao Mao

1,789
13
13

dont see a folder called 'mysql' in any of those locations – Alan Quigley Jul 05 '11 at 19:32
In that case, the Mysql client libraries are probably not installed correctly. How did you install mysql? – Zhehao Mao Jul 05 '11 at 19:47
I installed the Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive – Alan Quigley Jul 05 '11 at 19:56
Hmm, that is odd. Is there anything with mysql in its name in any of those directories. – Zhehao Mao Jul 05 '11 at 19:58
nothing, tried on a separate OSX 10.6 machine with the same error. – Alan Quigley Jul 06 '11 at 08:34

Problem setting up MySQL with python on OSX 10.6

1 Answers1