Drop support for MySQL 5 in CMS 6

[GuySartorelli]

MySQL 5 went EOL in 2023. We should stop supporting it.

Acceptance Criteria

• Any mention of MySQL 5 in the docs on the 6 branch is either removed or updated
• Any code which specifically handled differences between MySQL 5 and 8 is updated to only handle 8
• CI runs for testing MySQL 5 no longer run for CMS 6
• The changelog calls out this change and reminds people that we support and test against the latest LTS releases of MySQL and MariaDB

PRs

• ENH Drop MySQL 5.7 for CMS 6 gha-generate-matrix#106
• DEP Remove support for MySQL 5 #11354
• DOC Remove support for MySQL 5 developer-docs#570

[NightJar]

Is there any code that is even MySQL specific? Enums.
Is there any code that is even MySQL 5 specific? I don't even know what that looks like, they both parse SQL.
There was that one gotcha with the output of some introspection query being different... but that's already patched.

Is there any impact to MariaDB support with a change like this?

[GuySartorelli]

Is there any code that is even MySQL 5 specific?

I know some of the tests run conditionally on what version of mysql is being run, so possibly.

Is there any impact to MariaDB support with a change like this?

There shouldn't be.

[GuySartorelli]

PRs merged