This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-22. For the latest, interactive version please visit https://mariadb.com/kb/.

VERSION

Syntax

VERSION()

Description

Returns a string that indicates the MariaDB server version. The string uses the utf8 character set.

Examples

SELECT VERSION();
+----------------+
| VERSION()      |
+----------------+
| 10.4.7-MariaDB |
+----------------+

The VERSION() string may have one or more of the following suffixes:

SuffixDescription
-embeddedThe server is an embedded server (libmariadbd).
-logGeneral logging, slow logging or binary (replication) logging is enabled.
-debugThe server is compiled for debugging.
-valgrind The server is compiled to be instrumented with valgrind.

Changing the Version String

Some old legacy code may break because they are parsing the VERSION string and expecting a MySQL string or a simple version string like Joomla til API17, see MDEV-7780.

One can fool these applications by setting the version string from the command line or the my.cnf files with --version=....

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.