DB requirements for next major were changed

Migrated issue

Reported by: fjgarlin

Related to !203 (merged)

Problem/Motivation

https://git.drupalcode.org/issue/token-3445829/-/jobs/1591554

It appears that Drupal 11 has raised the minimum version required for MySQL to 8.

Steps to reproduce

Set OPT_IN_TEST_NEXT_MAJOR: 1

Proposed resolution

Use CORE_MYSQL_NEXT and set it for the "next major" jobs that require a database.

Remaining tasks

MR

Related issue: Issue #3215207

Related issue: Issue #3444792