How do I Check the MySQL Database Version?

Retrieving MySQL Database Management System (DBMS) Version

To determine the current version of a MySQL database, you can utilize several commands:

Method 1: VERSION() Function

The simplest method is to use the VERSION() function, which returns the MySQL version as a single string:

SELECT VERSION();
-- Returns '5.7.22-standard'

Method 2: SHOW VARIABLES Command

For more detailed information, you can use the SHOW VARIABLES command with a wildcard filter:

SHOW VARIABLES LIKE '%version%';
-- Returns a table of variables related to the MySQL version

This command provides additional details such as the protocol version, compile machine, and compile operating system.

Example Output

The following output shows the results of using the SHOW VARIABLES command:

+-------------------------+------------------------------------------+
| Variable_name           | Value                                    |
+-------------------------+------------------------------------------+
| protocol_version        | 10                                       |
| version                 | 5.0.27-standard                          |
| version_comment         | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686                                     |
| version_compile_os      | pc-linux-gnu                             |
+-------------------------+------------------------------------------+
5 rows in set (0.04 sec)

Additional Notes

• The VERSION() function can be used in both interactive and scripted environments.
• The SHOW VARIABLES command is available in MySQL versions 4.0 and later.
• For more information on determining the MySQL version, refer to the MySQL 5.0 Reference Manual (pdf), page 42.

The above is the detailed content of How do I Check the MySQL Database Version?. For more information, please follow other related articles on the PHP Chinese website!