Install mysql2 on MacOS Catalina

mysql2-catalina.md

Problem

Installing mysql2 gem errors on MacOS Catalina with MySQL 5.7.

Solution

Make sure openssl is installed on Mac via Homebrew.

brew install openssl

Install mysql2 gem.

gem install mysql2 -v '0.5.3' -- --with-mysql-config=$(brew --prefix mysql@5.7)/bin/mysql_config --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

If you want to bundle mysql2 you need to set these flags via bundle config:
bundle config build.mysql2 --with-opt-dir=$(brew --prefix openssl)

On my Mac OS Catalina (with MySQL 8) setting --with-cppflags generated this error:

clang: error: unsupported option '--with-cppflags=-I/usr/local/opt/openssl/include'

Credit to this comment.

Did you ever find a workaround for this? I've been doing any and everything to get the mysql2 gem installed in a rails project with no luck. I'm at Catalina 10.15.7

I also had this problem in an old project. (already had installed openssl and mysql@5.7)
upgrading bundler from 1.17.3 to 2.2.9 worked for me.

I've tried your different git for Mojave and worked for me:
gem install mysql2 -v '0.5.2' -- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

I've tried your different git for Mojave and worked for me:
gem install mysql2 -v '0.5.2' -- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

worked for me as well . been searching the internet for over 4 hours. MacOs Big Sur 11.2