Update recommended version of MariaDB to 10.5 or later

[peterwilsoncc]

MariaDB 10.4 has reached the end of life with 10.4.34 being the final release.

To ensure WordPress is recommending a supported version of the software, the recommended version should be updated to 10.5 or greater.

See ​#meta7679 for WordPress.org changes.

MariaDB 10.4 has reached the end of life with 10.4.34 being the final release.

To ensure WordPress is recommending a supported version of the software, the recommended version should be updated to 10.5 or greater.

https://core.trac.wordpress.org/ticket/61458

@peterwilsoncc do we needs to update unit test workflow file?

do we needs to update unit test workflow file?

I don't think so, the test in question pulls the version number from the readme file.

​https://github.com/WordPress/wordpress-develop/blob/f08a36944570fc2522ddb9f096a6b932c0529182/tests/phpunit/tests/readme.php#L63-L85

Example of a failed PHPUnit run without the changes to the site health file. ​https://github.com/WordPress/wordpress-develop/actions/runs/9559915819/job/26351138684

[peterwilsoncc]

In the ​linked pull request:

• Update readme to recommend MariaDB 10.5 or greater
• Update the Site Health report for same
• Unskip the Site Health tests test_mysql_recommended_version_matches_readme_html() and test_mariadb_recommended_version_matches_readme_html() to run on all branches as they ensure the readme and Site Health are consistent without regard to EOL status

[hellofromTonya]

Patch: ​https://github.com/WordPress/wordpress-develop/pull/6848

As @peterwilsoncc noted, the patch combines the individual commits done for 10.4:

• General bump in the readme as a follow-up to [53435].
• Site Health bump as a follow-up to [54069].
• It will now run the tests on all branches with this change, as a follow-up to [53435].

​LGTM for commit 👍

​The Requirements page is now updated with this recommendation, as its Meta ticket closed today ​https://meta.trac.wordpress.org/ticket/7679 👍

Changing this ticket to Blessed Task (as it was for the last bump) and moving it into the 6.6 milestone.

[hellofromTonya]

Prepping the commit now, which will resolve the failing tests.

[hellofromTonya]

In 58432:

Site Health: Bump the recommended MariaDB version.

MariaDB 10.4 reaches EOL (“End of Life”) on 18 June 2024. The recommended minimum is bumped to 10.5 for now, whose EOL is 24 June 2025.

Also removes the skip in tests to allow the tests to run on all branches with this change.

References:

• ​MySQL Support Policies
• ​Hosting team handbook: Server Environment: Database

Follow-up to [55665], [52420], [53435], [54069], [54076].

Props peterwilsoncc, dd32, costdev, mukesh27, hellofromTonya.
Fixes #61458.
See ​#meta7679.

Committed via https://core.trac.wordpress.org/changeset/58432.