@sierdzio Thank you a lot for your answer !
Your explaination on the opaque pointer is clear, I didn't have that notion before.
With this knowledge, most of my questions are wrong, like the 5th.
I just solved the issue following this video. Using the command provided in solution 1 did the trick.
The command I used is the following:
sudo ln -s /usr/local/mysql/lib/libmysqlclient.21.dylib /usr/local/lib/libmysqlclient.21.dylib
The explanation of how this works is in that video, for anyone stepping with this problem in the future.
Thanks @jsulm for your help and time.