[MacPorts] #69930: Add mysql8 variant

[MacPorts]

#69930: Add mysql8 variant
-------------------------+-------------------------
 Reporter:  clouseau     |      Owner:  ryandesign
     Type:  enhancement  |     Status:  assigned
 Priority:  Normal       |  Milestone:
Component:  ports        |    Version:  2.9.3
 Keywords:               |       Port:  php82-mysql
-------------------------+-------------------------
 The php81-mysql port has a variety of variants that include mutually
 exclusive libraries for mariadb, mysql57, mysql8, etc. These are are
 listed in the "Loaded plugins" row under the mysqlnd section of phpinfo().

 The php82-mysql port has only debug and universal variants. The default
 variant does not install the
 auth_plugin_caching_sha2_password,auth_plugin_sha256_password mysqlnd
 plugins that are installed, for example, with port install php81-mysql
 +mysql8.

 Thus, php82 with php82-mysql on MacPorts is currently not usable with
 MySQL 8 default password authentication (caching_sha2_password) resulting
 in "The server requested authentication method unknown to the client
 [caching_sha2_password]".

 We would be grateful if a mysql8 variant of php82-mysql could be created.

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