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

Show statement

Option 1 - Specific information

Query

show variables where variable_name = 'version_comment';

Columns

• Variable_name - name of the variable
• Value - MySQL edition information

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: represens 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

Sample results