### How to install mysql2 0.5.3 gem on Ruby 2.7.8 + Homebrew MySQL 8.0 environment

```sh
# this is installed via asdf
$ ruby -v
ruby 2.7.8p225 (2023-03-30 revision 1f4d455848) [x86_64-darwin24]

$ brew list --versions | grep mysql
mysql-client 9.0.1
mysql-client@8.0 8.0.39
mysql@8.0 8.0.39_5

$ brew info mysql@8.0 | grep FLAGS
  export LDFLAGS="-L/usr/local/opt/mysql@8.0/lib"
  export CPPFLAGS="-I/usr/local/opt/mysql@8.0/include"

# replace --with-ldflags and --with-cppflags with values returned from previous command
$ gem install mysql2 -v '0.5.3' -- --with-ldflags='-L/usr/local/opt/mysql@8.0/lib' --with-cppflags='-I/usr/local/opt/mysql@8.0/include' --with-cflags="-Wno-incompatible-pointer-types -Wdeprecated-non-prototype -Wincompatible-function-pointer-types"

$ bundle
```