python accessing mysql db not able to load the library

Question

I am using python 2.7 and MySQLdb, while doing import MySQLdb its throwing below error -

import MySQLdb
  File "/Library/Python/2.7/site-packages/MySQLdb/__init__.py", line 19, in <module>
    import _mysql
ImportError: dlopen(/Library/Python/2.7/site-packages/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib
  Referenced from: /Library/Python/2.7/site-packages/_mysql.so
  Reason: image not found

Add the path in etc/profile > export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH stackoverflow.com/questions/5081574/… — Mutant
– Mutant, Commented Feb 19, 2012 at 16:03

Chris · Accepted Answer · 2012-02-19 14:59:54Z

1

You need to have the mysql client installed on your system.

If you have, then you have the file libmysqlclient.18.dylib located somewhere on your system. Make sure the path where it is located is included in your DYLD_LIBRARY_PATH environment variable.

answered Feb 19, 2012 at 14:59

Chris

3,12128 silver badges33 bronze badges

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

7 Comments

Mutant Over a year ago

i do have client installed and path is included for environment variable more ~/.bash_profile DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/usr/local/mysql/lib/ PATH=$PATH:/usr/local/mysql/bin:/Users/Jaimin/Development/Django-1.3.1/django/bin/

Chris Over a year ago

Is the file libmysqlclient.18.dylib in the folder /usr/local/mysql/lib/? If not, is a different version located there?

Mutant Over a year ago

file is there, here is the list of file in there >libmysqlclient.18.dylib libmysqlclient_r.18.dylib libmysqld-debug.a plugin libmysqlclient.a libmysqlclient_r.a libmysqld.a libmysqlclient.dylib libmysqlclient_r.dylib libmysqlservices.a

Chris Over a year ago

Unless you are starting python from a bash shell (not the terminal app) you need to set the environment variables in your environment.plist. Editing .bash_profile affects only bash shells (and only if you restarted your mac)

Mutant Over a year ago

:) I am starting from terminal app and have restarted mac right after install and setting up bash_profile...tried to read the variable on terminal it doesn't recognize though it recognize PATH from it..so really not sure whats going on.

|

Collectives™ on Stack Overflow

python accessing mysql db not able to load the library

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related