➜  bridge git:(chore/BB-11279/available_positions) rails db:migrate
rails aborted!
LoadError: dlopen(/Users/user01/.rbenv/versions/3.1.6/lib/ruby/gems/3.1.0/gems/mysql2-0.5.6/lib/mysql2/mysql2.bundle, 0x0009): Library not loaded: /usr/local/opt/mysql/lib/libmysqlclient.24.dylib
  Referenced from: <9A9C1460-63D0-353B-93C2-C14C33048103> /Users/ralvarado/.rbenv/versions/3.1.6/lib/ruby/gems/3.1.0/gems/mysql2-0.5.6/lib/mysql2/mysql2.bundle
  Reason: tried: '/usr/local/opt/mysql/lib/libmysqlclient.24.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/opt/mysql/lib/libmysqlclient.24.dylib' (no such file), '/usr/local/opt/mysql/lib/libmysqlclient.24.dylib' (no such file) - /Users/user01/.rbenv/versions/3.1.6/lib/ruby/gems/3.1.0/gems/mysql2-0.5.6/lib/mysql2/mysql2.bundle
/Users/user01/Documents/Projects/hivetec/bridge-new/bridge/config/application.rb:4:in `'
/Users/user01/Documents/Projects/hivetec/bridge-new/bridge/Rakefile:6:in `require_relative'
/Users/user01/Documents/Projects/hivetec/bridge-new/bridge/Rakefile:6:in `'
bin/rails:4:in `'

Solution:
~# gem uninstall mysql2   
~# gem install mysql2 -v '0.5.6' -- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/i
~# gem pristine mysql2
~# rails db:migrate or rails server