tl;dr: The version you are seeing is not "wrong".

You could set a custom version string from MariaDB 10.2.6 onwards (see here) but not earlier. And just fixing the version displayed might break other things yet to be known...

As long as MariaDB stays reasonably compatible with MySQL there should be no problems.

In detail this is a result of how MariaDB reports it's version. Take for example the following code:

$db = new PDO('mysql:host=127.0.0.1', 'root', 'password');
echo $db->getAttribute(PDO::ATTR_SERVER_VERSION);

If you execute this on your server in an interactive PHP shell (php -a) you should receive something like 5.5.5-10.0.31-MariaDB (an Ubuntu 16.04 installation I just looked this up in returned 5.5.5-10.0.29-MariaDB-0ubuntu0.16.04.1).

After receiving this value the underlying Zend_Db_Adapter_Pdo_Abstract extracts and returns (see here) just the first part of it. That is where your 5.5.5 is coming from.

Even further down the rabbit hole you see the MariaDB source code with an explanation (see here) about why they did that. Also mentioning they manually patched their clients to just strip this version from getting printed.

Uh oh!

MariaDB version not displayed correctly #11934

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions