Readme: Update recommendations (include MariaDB) to reflect https://wordpress.org/about/requirements/

[Presskopp]

The readme.html misses MariaDB:

​https://wordpress.org/about/requirements/ recommends:
PHP version 7 or greater
MySQL version 5.6 or greater OR MariaDB version 10.0 or greater

readme:
MySQL version 5.6 or higher.

[pento]

I'm cool with making this change, but let's wait until after #30462 - running the test suite against MariaDB is helpful in declaring it properly supported.

As with MySQL and PHP, the recommended version should be dependent the dates​ declared in the MariaDB ​Maintenance Policy.

[desrosj]

I'd like to prioritize this for 5.9.

Trac ticket: https://core.trac.wordpress.org/ticket/41490

[audrasjb]

PR available for this change :)

[audrasjb]

Changing this ticket into a task.

[audrasjb]

The PR above is almost ready. Self-assigning the ticket.

[audrasjb]

As per yesterday's bug scrub, I'm committing the first part (add MariaDB recommendation), then I'll reopen the ticket to see if the Unit Test part can land in 5.9 or not.

[audrasjb]

In 52319:

General: Add MariaDB in the readme.html requirements.

This change updates the WordPress readme.html file to reflect WordPress.org requirements: as of WordPress 5.9, MariaDB 10.1 and higher versions are supported by WP. See ​https://wordpress.org/about/requirements/.

Fixes #41490.

[audrasjb]

Reopening to see if we can add some unit tests for this.

Worth noting that we recently deactivated the test for the PHP version. Also, the same goes for MariaDB: we recommend to use 10.1 and greater on w.org but the last supported version on MariaDB’s side is 10.2.

[JavierCasares]

Only FYI… Now, we are recommending:

— PHP version 7.4 or greater.
— MySQL version 5.6 or greater OR MariaDB version 10.1 or greater.
— HTTPS support

OK to PHP 7.4+

MySQL, the latest GA available version is MySQL 5.7 / 8.0 (5.6 is not supported anymore)

Same with MariaDB. Now, the latest GA version supported is MariaDB 10.2…

Should we recommend unsupported / insecure versions?

We should clarify if this page is for "requirements" or "recommendations" because, as requirements, WordPress may work with many older versions, but as recommended we should not propose unsupported versions.

[SergeyBiryukov]

Replying to JavierCasares:

We should clarify if this page is for "requirements" or "recommendations" because, as requirements, WordPress may work with many older versions, but as recommended we should not propose unsupported versions.

I agree we should not recommend unsupported or insecure versions.

The ​Requirements page looks like a mix of both recommendations and requirements, with the recommendations at the top and the actual requirements a bit further down:

Note: If you are in a legacy environment where you only have older PHP or MySQL versions, WordPress also works with PHP 5.6.20+ and MySQL 5.0+, but these versions have reached official End Of Life and as such may expose your site to security vulnerabilities.

[SergeyBiryukov]

In 52358:

General: Mark the recommended MariaDB version number in readme.html with a <strong> tag.

This brings consistency with the MySQL version number.

Follow-up to [52319].

See #41490.