Error with MySQLdb on OS X El Capitan

Question

I tried importing the MySQLdb within iPython and received the following error.

ImportError                               Traceback (most recent call last)
<ipython-input-4-f5538763dbdb> in <module>()
----> 1 import MySQLdb as mdb
      2 import sys

/Users/user1/anaconda/lib/python2.7/site-packages/MySQLdb/__init__.py in <module>()
     17 from MySQLdb.release import __version__, version_info, __author__
     18 
---> 19 import _mysql
     20 
     21 if version_info != _mysql.version_info:

ImportError: dlopen(/Users/user1/anaconda/lib/python2.7/site-packages/_mysql.so, 2): Library not loaded: libssl.1.0.0.dylib
  Referenced from: /Users/user1/anaconda/lib/python2.7/site-packages/_mysql.so
  Reason: image not found

I found a few posts on Stackoverflow of a similar nature, where it was suggested that the System Integrity Protection should be disabled, which I have now.

I also edited my bashprofile as suggested for OSX El Capitan in this post, Python mysqldb: Library not loaded: libmysqlclient.18.dylib but I still haven't been able to overcome this issue.

A little more information incase it helps diagnose the issue:

Python version: Python 2.7.10 |Anaconda 2.4.0 (x86_64)| (default, Oct 19 2015, 18:31:17) [GCC 4.2.1 (Apple Inc. build 5577)]
Result of 'which python' : /Users/user1/anaconda/bin/python
MySQL Version installed: mysql-5.7.10
MySQL-Python version: MySQL-python-1.2.5

Where am I going wrong?

I edited my bash profile as mentioned on https://stackoverflow.com/questions/27264574/import-psycopg2-library-not-loaded-libssl-1-0-0-dylib, but still no solution. — user2762934, Jan 23 '16 at 17:06

score 5 · Answer 1 · answered Mar 05 '19 at 05:16

5

you can try:

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

answered Mar 05 '19 at 05:16

Saurabh Kushwaha

111
2
4

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/ helped for me – Taras Nov 02 '19 at 12:31
after trying a number of other suggestions to solve this issue whilst trying to get django to work with mysql on os x, this worked for me as well – A Steinmetz Jan 30 '20 at 05:25

score 4 · Accepted Answer · edited May 23 '17 at 12:32

4

After some research, I figured that the issue might have been due to OpenSSL, and permissions related to this in El Capitan. I found two resources which hinted at similar solutions:

So here it is:

brew install --upgrade openssl
brew unlink openssl && brew link openssl --force

edited May 23 '17 at 12:32

Community

1
1

answered Jan 23 '16 at 17:13

user2762934

2,332
10
33
39

1

`Warning: Refusing to link macOS-provided software: openssl` – User Dec 22 '18 at 20:04

score 0 · Answer 3 · answered Mar 27 '17 at 21:54

I had the same problem and tried a few things including the brew install, unlink, link solution without any luck. For OS X 10.12.3 running Python 2.7.12, Anaconda 2.3.0 the following worked for me.

Turn off System Integrity Protection: Reboot the Mac and hold down Command + R, open the terminal and enter: csrutil disable; reboot
After rebooting: cd /usr/local/Cellar/openssl/1.0.2k/lib sudo cp libssl.1.0.0.dylib libcrypto.1.0.0.dylib /usr/lib/

Error with MySQLdb on OS X El Capitan

3 Answers3

Linked