The queries below return the MariaDB version, edition and system information.

Version variable

Query

select @@version as version;

Note: @@version can be replaced by version()

Columns

• version - MariaDB version

Rows

• The query returns just one row

Sample results

Show statement

Option 1 - Specific information

Query

show variables where variable_name = 'version'

Columns

• Variable_name - name of the variable
• Value - MariaDB version number

Rows

• The query returns just one row

Sample results

Option 2 - Detailed information

Query

show variables where variable_name like '%version%'

Columns

• Variable_name - name of the variable
• Value - value stored in the variable

Rows

• One row: represents the value of the corresponding variable
• Scope of rows: information such as version, edition and system information

Sample results

MySQL Workbench

In the Navigator pane to the left of the screen, click on the option Server Status to display the MariaDB version and edition, along with some system information