Modifying DYLD_LIBRARY_PATH for mysql, python, and django

Question

I've seen two dozen posts concerning this issue, but I'm so NOOB I'm not sure how to modify everything correctly.

I'm attempting to finish the installation, but when I go to Python and "import MySQLdb" I end up getting:

ImportError: dlopen(/Users/pccampbell/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.5-fat3.egg-tmp/_mysql.so, 2):


Library not loaded: libmysqlclient.16.dylib

Referenced from: /Users/pccampbell/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.5-fat3.egg-tmp/_mysql.so

I then run this command which everyone says works (and it does, but only temporarily!):

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

SO, I'm trying to execute the following to permanently change the path (as found on another help site):

sudo install_name_tool -change libmysqlclient.16.dylib /usr/local/mysql/lib/libmysqlclient.16.dylib lib/python2.7/site-packages/_mysql.so

BUT, I end up getting this error:

install_name_tool: can't open file: lib/python2.7/site-packages/_mysql.so (No such file or directory)

I found the _mysql.so file at, but even when I use this path it doesn't work:

/Users/pccampbell/MySQL-python-1.2.3/build/lib.macosx-10.5-fat3-2.7

THE BOTTOM LINE: is there a way to permanently modify the DYLD_LIBRARY_PATH, so I don't have to run the export command every time. If so, then could you please, please, please provide the specific syntax, because I've been guessing and checking for a long time. :(

ANy help GREATLY appreciated.

Patrick

Mark Hall · Accepted Answer · 2011-12-22 20:41:39Z

14

According to Matt's idea, in mac os x Lion, you should add the following sentence like this to your /etc/profile:

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

edited Dec 22, 2011 at 20:41

Mark Hall

54.7k9 gold badges101 silver badges116 bronze badges

answered Dec 22, 2011 at 20:04

vutran

2,17521 silver badges34 bronze badges

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

Comments

bool.dev · Accepted Answer · 2012-10-15 19:42:52Z

8

add the export command to /etc/profile as follows:

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib

Note:There is no "/" after lib above. If you add / after lib, and try installing MySQL-python, the errors will keep occuring when running ">>import MySQLdb"

I hope this solves the problem for you! :-)

edited Oct 15, 2012 at 19:42

bool.dev

17.5k5 gold badges71 silver badges93 bronze badges

answered Mar 18, 2011 at 2:15

Matt Manoj

811 bronze badge

Collectives™ on Stack Overflow

Modifying DYLD_LIBRARY_PATH for mysql, python, and django

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related