Problem installing MySQL-Python on Mac OS 10.14.1

Question

I recently upgraded to Mac OS Mojave and now can't install MySQL-Python:

pip install MySQL-Python

...
clang -bundle -undefined dynamic_lookup build/temp.macosx-10.13-x86_64-2.7/_mysql.o -L/usr/local/opt/mysql-client/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.13-x86_64-2.7/_mysql.so
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command 'clang' failed with exit status 1

The stack trace says that the "ssl" library wasn't found. I'm not sure what that means though as I have the latest XCode and OpenSSL is installed. Any advice appreciated.

user5194377 · Accepted Answer · 2018-12-12 22:47:44Z

5

I had the same issue on MacOS 10.14, and I was able to solve it using these steps:

Change permissions for /usr/local to allow Homebrew to create links:

sudo chown -R $(whoami) $(brew --prefix)/*

Re-install openssl now that permissions have been fixed:

brew reinstall openssl

Run these two commands to allow compilers to find openssl:

export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"

Then, try again to install MySQL-Python:

pip install MySQL-Python

answered Dec 12, 2018 at 22:47

user5194377

1131 silver badge6 bronze badges

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

Comments

Ming Geng · Accepted Answer · 2019-02-06 07:36:13Z

1

Change permissions for /usr/local to allow Homebrew to create links:
sudo chown -R $(whoami) $(brew --prefix)/*
Re-install openssl now that permissions have been fixed:
brew reinstall openssl
Run these two commands to allow compilers to find openssl:
export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"
Then, try again to install MySQL-Python:
pip install MySQL-Python

It works for Mac 10.14.2 with python2.7 /Django 1.9.8 and mysql-server 8 with mysql-clinet;

edited Feb 6, 2019 at 7:36

answered Feb 6, 2019 at 7:29

Ming Geng

112 bronze badges

1 Comment

SeaWarrior404 Over a year ago

As of 2019, this is the only valid solution which works on a mac. Other answers on SO which suggest link/unlink of mysql c connector simply dont work. Thanks!

Collectives™ on Stack Overflow

Problem installing MySQL-Python on Mac OS 10.14.1

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related