p5-DBD-mysql make consumers aware of p5-DBD-mysql4 and choose correct version based on MYSQL_FLAVOUR

[flo]

Summary

D44524 added databases/p5-DBD-mysql4 to the tree that can still be used with MariaDB.
Make all p5-DBD-mysql consumers aware of both versions and choose the correct one to install based on MYSQL_FLAVOUR

[vvd]

I read all patch and it look good for me: PORTREVISION++, *_DEPENDS=${DBD_MYSQL}, *USES+=mysql.
If you want me to test the build in poudriere, I need more time.

[flo]

In D44662#1018235, @vvd wrote:

If you want me to test the build in poudriere, I need more time.

I tested the build of all changed ports with the default mysql version and with DEFAULT_VERSIONS+=mysql=10.11m. Everything builds fine except net/radiator because I don't have the restricted distfile and net-mgmt/netdot which is broken because it still uses @unexec.

[vvd]

Maybe add record to UPDATING?

20240407:
  AFFECTS: users of databases/p5-DBD-mysql if use databases/mariadb10{5,6,11}-client
  AUTHOR: [e-mail]

  Upstream removed support of the MariaDB from branch 5.0. Branch 4.0 is still supported.

  pkg users:
        pkg set -o databases/p5-DBD-mysql:databases/p5-DBD-mysql4
        pkg upgrade

  Portmaster users:
        portmaster -o databases/p5-DBD-mysql4 databases/p5-DBD-mysql
        portmaster -a

  Portupgrade users:
        portupgrade -o databases/p5-DBD-mysql4 -f databases/p5-DBD-mysql
        portupgrade -a

My english is poor - the message require fix or even add more details.