Install mysql2 on MacOS Mojave

mysql2-mojave.md

For MacOS Catalina, visit Install mysql2 on MacOS Catalina

Problem

Installing mysql2 gem errors on MacOS Mojave.

Solution

Make sure openssl is installed on Mac via Homebrew.

brew install openssl

Install mysql2 gem.

gem install mysql2 -v '0.5.2' -- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

Thanks @gukandrew 🥳

Thanks worked like a charm @gukandrew

bundle config build.mysql2 --srcdir=/usr/local/mysql/include
bundle install

This worked for me on MacOS Monterey w/ Macbook Air M1 2020

@gukandrew confirmed working for me on my MBA M1 2020

In case none of the solutions above worked for you on an Apple M1 silicon, you may want to have a look at this one:
brianmario/mysql2#1175 (comment)

This:

bundle config build.mysql2 --srcdir=/usr/local/mysql/include
bundle install

worked for me on Monterey 12.2.1 with M1 chip

Thank you @bparanj. That worked perfectly for me as well.

Tried all of the solutions from multiple sources/websites and the only one that worked on a M2 2023 was gem install mysql2 -v '0.3.18' -- --srcdir=/opt/homebrew/Cellar/mysql/8.0.33_2/include. Other solutions were working for more recent versions of the mysql2 gem though.

Tried all of the solutions from multiple sources/websites and the only one that worked on a M2 2023 was gem install mysql2 -v '0.3.18' -- --srcdir=/opt/homebrew/Cellar/mysql/8.0.33_2/include. Other solutions were working for more recent versions of the mysql2 gem though.

Awesome!!! This was the only solution that worked for me. You saved my day!