[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 BjarneDMat):

 **further analysis**\\
 on my system (Catalina 10.15.7) the following ports fail to rev-upgrade:\\
 * dovecot @2.3.21_0+ldap+mysql8 (active)
 * p5.34-dbd-mysql @5.3.0_1+mysql8 (active)
 * postfix @3.9.0_0+dovecot_sasl+mysql8+pcre (active)
 They configure themselves w/ mysql8 in two (2) different ways:
 * executing {{{/opt/local/lib/mysql8/bin/mysql_config}}}
 * {{{lappend CCARGS  -DHAS_MYSQL
 -I${prefix}/include/mysql8/mysql}}}\\{{{set ::named_auxlibs(AUXLIBS_MYSQL)
 "-L${prefix}/lib/mysql8/mysql -lmysqlclient -lz -lm"}}}
 This leads to two (2) possible solutions:
 * modify the MACPORTS mysql8 layout in {{{patch-cmake-
 install_layout.cmake.diff}}}
 * modify **BOTH** {{{mysql_config}}} and **all** Portfiles that call the
 {{{libmysqlclient.dylib}}} directly
 So, my proposed solution is to revert the changes made to {{{patch-cmake-
 install_layout.cmake.diff}}} in commit
 eeeb795e625ad50f416e8f69ff9dc520f7021c80

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