MySQLdb for Python 2.7 on OSX 10.8.2 and BOTH are 64 bit

Question

Here's my problem: I can't Get MySQLdb for python working. Most of the other posts regarding this have cited having different architectures of MySQL/Python. I checked, and they're both 64 bit. I have Python 2.7.2 (standard OS X) and the latest MySQL, OS X 10.8.2. my original error logs: Trying to import MySQL db gives me this error: ``` Traceback (most recent call last): File "", line 1, in File "/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/MySQLdb/__init__.py", line 19, in import _mysql ImportError: dlopen(/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib Referenced from: /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/_mysql.so Reason: image not found ``` This might be helpful as well, the console output while I install mysql-python 1.2.4b4 ``` xxx-MBP:MySQL-python-1.2.4b4 me$ sudo python setup.p…

Accepted Answer

I THINK I GOT IT! Here's what I did.

OK this has been extremely frustrating.

What finally made it work was doing this in the terminal :

```
sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib
```

But there was alot of other stuff before that. I mixed the directions from two sources:

How to install MySQLdb (Python data access library to MySQL) on Mac OS X? and http://birdhouse.org/blog/2009/02/21/python-mysql-connections-on-mac-os/

I used the first to clean python and change the build files… I used the second to add 64 bit flags to install and build…

Then I used an answer at Error importing MySQLdb in Python 2.7.2 on Mac OSx 10.8.1 (which was the final thing that made it work.)

to set me over the edge.

I’m not sure exactly what made a difference because I did SO MANY THINGS. I deleted a bunch of stuff from the 2.7 python folder….and other things. But the only thing i can be sure of is that mixing the directions from those two sources made a difference. Thanks for all the help, guys….lol I hope this saves somebody a headache.

MySQLdb for Python 2.7 on OSX 10.8.2 and BOTH are 64 bit

Solution

Problem