How to Check the MySQL Version

 

From the Command Line

Use the following command to check the version of your local MySQL server. This command is not specific to any operating system. This command is compatible with all Linux, Windows, and macOS versions running MySQL.

mysql -V

 Here is the output.

# mysql -V
mysql  Ver 14.14 Distrib 5.7.15, for Win32 (AMD64)

 

SELECT VERSION Statement

Use the SELECT VERSION() command in the MySQL database client to check the MySQL version.

SELECT version();

Here is the output.

MariaDB [***]> SELECT version();
+-----------------+
| version()       |
+-----------------+
| 10.3.37-MariaDB |
+-----------------+
1 row in set (0.000 sec)