[MacPorts] #69930: php82-mysql, php83-mysql: Add mysql8 variant

[MacPorts]

#69930: php82-mysql, php83-mysql: Add mysql8 variant
---------------------------------------+------------------------
  Reporter:  clouseau                  |      Owner:  ryandesign
      Type:  enhancement               |     Status:  accepted
  Priority:  Normal                    |  Milestone:
 Component:  ports                     |    Version:  2.9.3
Resolution:                            |   Keywords:
      Port:  php82-mysql, php83-mysql  |
---------------------------------------+------------------------

Comment (by clouseau):

 Thank you. However, with this change we are still at the point where
 installation results in missing plugins, so that PHP >8.1 on MacPorts does
 not support the default caching_sha2_password authentication method of
 MySQL 8.

 Macports (port install php82-mysql +mysql8):

 {{{
 /opt/local/bin/php82 -i | grep 'Loaded plugins'
 Loaded plugins =>
 mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
 }}}

 Homebrew (brew install shivammathur/php/php at 8.2):

 {{{
 /opt/homebrew/bin/php -i | grep 'Loaded plugins'
 Loaded plugins =>
 mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
 }}}

 RHEL 9.4 with PHP 8.2.13:

 {{{
 /usr/bin/php -i | grep 'Loaded plugins'
 Loaded plugins =>
 mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
 }}}

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