W3cubDocs

/MariaDB

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:

Suffix Description
-embedded The server is an embedded server (libmysqld).
-log General logging, slow logging or binary (replication) logging is enabled.
-debug The 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.

From MariaDB 10.2, 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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/version/