opam install mysql8 fails on Mac OS

[ThomasBrittain]

Hi - is this library still supported? I'm running into some issues installing the package on my mac via opam, and I strongly suspect its related to my installation of mysql8 being installed via homebrew. I've tried everything I could, but seems homebrew might just be using non-standard directories that aren't easily recognized by opam?

Running opam install mysql8:

% opam install mysql8
The following actions will be performed:
∗ install mysql8 1.0

<><> Processing actions <><><><><><><><><><><><><><><><><><><><><><><><><><> 🐫
⬇ retrieved mysql8.1.0 (cached)
[ERROR] The compilation of mysql8.1.0 failed at "dune build -p mysql8 -j 7".

#=== ERROR while compiling mysql8.1.0 =========================================#
# context 2.1.2 | macos/arm64 | ocaml.4.14.0 | https://opam.ocaml.org#6e1e57ea
# path ~/.opam/default/.opam-switch/build/mysql8.1.0
# command ~/.opam/opam-init/hooks/sandbox.sh build dune build -p mysql8 -j 7
# exit-code 1
# env-file ~/.opam/log/mysql8-92507-207aec.env
# output-file ~/.opam/log/mysql8-92507-207aec.out
### output ###
# File "lib/dune", line 4, characters 10-22:
# 4 | (c_names mysql8_stubs)
# ^^^^^^^^^^^^
# (cd _build/default/lib && /usr/bin/cc -O2 -fno-strict-aliasing -fwrapv -pthread -D_FILE_OFFSET_BITS=64 -g -I /Users/thomas/.opam/default/lib/ocaml -I /Users/thomas/.opam/default/lib/base -I /Users/thomas/.opam/default/lib/base/base_internalhash_types -I /Users/thomas/.opam/default/lib/base/caml -I /Users/thomas/.opam/default/lib/base/shadow_stdlib -I /Users/thomas/.opam/default/lib/jane-stree[...]
# mysql8_stubs.c:38:10: fatal error: 'mysql.h' file not found
# #include <mysql.h>
# ^~~~~~~~~
# 1 error generated.

<><> Error report <><><><><><><><><><><><><><><><><><><><><><><><><><><><><> 🐫
┌─ The following actions failed
│ λ build mysql8 1.0
└─
╶─ No changes have been performed

[yami-no-ryuu]

It says you need to install mysql development files. It's either mysql or mysql-client packages if you don't need db server itself. Though it needs a patch for Mysql 8.3