[MacPorts] #70001: mysql8 @8.4.0: libmysqlclient install name and location changed; revbumps needed

[MacPorts]

#70001: mysql8 @8.4.0: libmysqlclient install name and location changed; revbumps
needed
-------------------------+-------------------------
  Reporter:  ryandesign  |      Owner:  herbygillot
      Type:  defect      |     Status:  assigned
  Priority:  Normal      |  Milestone:
 Component:  ports       |    Version:  2.9.3
Resolution:              |   Keywords:
      Port:  mysql8      |
-------------------------+-------------------------

Comment (by jhoyt4):

 Part of the p5-dbd-mysql issue is that it correctly uses mysql_config to
 find libmysqlclient, but libmysqlclient (installed with mysql8) still has
 a broken link dependency to itself.

 otool -L /opt/local/lib/**mysql8/lib**/libmysqlclient.dylib \\
     /opt/local/lib/**mysql8/lib**/libmysqlclient.dylib:\\
         /opt/local/lib/**mysql8/mysql**/libmysqlclient.24.dylib
 (compatibility version 24.0.0, current version 24.0.0)\\
         /opt/local/libexec/openssl3/lib/libssl.3.dylib (compatibility
 version 3.0.0, current version 3.0.0)\\
         /opt/local/libexec/openssl3/lib/libcrypto.3.dylib (compatibility
 version 3.0.0, current version 3.0.0)\\
         /usr/lib/libresolv.9.dylib (compatibility version 1.0.0, current
 version 1.0.0)\\
         /opt/local/lib/libz.1.dylib (compatibility version 1.0.0, current
 version 1.3.1)\\
         /opt/local/lib/libzstd.1.dylib (compatibility version 1.0.0,
 current version 1.5.6)\\
         /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current
 version 1700.255.0)\\
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 1345.100.2)\\

 When the p5-dbd-mysql's Makefile.pl calls assert_lib, assert_lib tries to
 find the missing dylib and errors out.

 This may also be some of the cause of the continuous requests to rev-
 update ports that link to libmysqlclient

-- 
Ticket URL: <https://trac.macports.org/ticket/70001#comment:15>
MacPorts <https://www.macports.org/>
Ports system for macOS