The queries below return MySQL version, edition and system information.

Version variable

Query

select @@version as version;

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

Columns

• version - MySQL version

Rows

• 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 - MySQL version number

Rows

• 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 MySQL version and edition, along with some system information