I just resolved this exact issue when running Ansible’s mysql_user module. The answer here helped tip me off to a solution. I also needed MySQL-python
from pip
, which also broke in this process, so I’ve added the extra steps.
Steps to resolve:
brew unlink mysql # only if installed, causes the next step to fail
brew install mysql-connector-c
- locate
mysql_config
file withwhich (mysql_config)
- edit the
mysql_config
file, under# Create options
change this:libs="$libs -l "
to this:libs="$libs -lmysqlclient -lssl -lcrypto"
if using vim,:wq!
to save the read-only file - Now the install should run successfully
pip install mysqlclient
- Adding this separately, as it’s similar but not directly related to the initial question
pip install MySQL-python
- Fix
mysql
brew formula, if it was unlinked in the first step.brew unlink mysql-connector-c
brew link mysql