Add libs='$libs -lmysqlclient -lssl -lcrypto' and save.

Find #Create options and comment in libs='$libs -l '.Open the file with sudo privileges by any editor.Find the file location by using the command ls -la `which mysql_config`.Install through Homebrew brew install mysql-connector-c brew install opensslĮcho 'export PATH='/usr/local/opt/openssl/bin:$PATH'' > ~/.bash_profileĮcho 'export PATH='/usr/local/opt/openssl/bin:$PATH'' > ~/.zshrc (if you are using zsh) Install and Configure MySQL connector C API Try ( which openssl) to check if already available. Make sure you have OpenSSL installed and the path is added in bash and/or zsh profile. PrerequisiteĪs a requirement of my solution, I assume you already have Homebrew installed on your machine, other than going to the official site about to installl it, should be pretty easy.

If you have MySQL server installed through Homebrew, we don’t expect you are facing any connection related problem. Bellows are focused on ´ MySQL-Python´, ´ mysqlclient´ installation problems and solutions. This writing for those concerns who don’t have MySQL server installed into MacOS powered development machine (like MacBook Pro) but need to work with MySQL connection through programming languages (i.e Python in my case). I am the mad (maybe fool) guy who doesn’t prefer to install services (like MySQL, PostgreSQL and so on) into development machine, instead using docker containers, this way gives me a lot of flexibilities, for example, I could have multiple versions of MySQL servers (each version could be project-specific depends on requirements), besides no unnecessary processes are running in my development machine. Solve that issue I manually create a file named “my_config.h” at /usr/local/opt/mysql-client/include/mysql and put contents from here Preface The latest version of you might don’t need to go Configure mysql_config section as I see that is already correctly configured.īut one file “ my_config.h“ is missing, you will feel that when you are going to install “ MySQL-Python“.

Install mysql client brew