Mac installation mysqlclient process analysis

Try installing via pip in a virtual environment:

pip install mysqlclient

Then an error is reported: OSError: mysql_config not found

Found the official document https://github.com/PyMySQL/mysqlclient-python, explaining that another module needs to be installed before installation:

brew install mysql-connector-c

But the error:

Check the error message and install mysql-connector-c before

brew unlink mysql

But continue to install or error:

Check the official instructions, it turns out that under macOS, you need to change the value in mysql_config

# on macOS, on or about line 112:
# Create options 
libs="-L$pkglibdir"
libs="$libs -l "

Change to

# Create options 
libs="-L$pkglibdir"
libs="$libs -lmysqlclient -lssl -lcrypto"

Next is easy, directly

which mysql_config

Find the file path, move to that path, modify the content with vim, exit and re-execute

pip install mysqlclient

It succeeded.

In fact, there are other modules for connecting to MySQL under Python, such as pymysql, etc., which are not so troublesome to install on Mac.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.