Check MySQL Database Version

Checking MySQL version can be done easily via mysql CLI or using SQL.

mysql CLI

$ mysql -V
mysql  Ver 14.14 Distrib 5.7.32, for Linux (x86_64) using  EditLine wrapper

SQL

We can either get it from database server variables or using version() function.

mysql> show variables LIKE 'version';
+---------------+-------------------------+
| Variable_name | Value                   |
+---------------+-------------------------+
| version       | 5.7.32-0ubuntu0.18.04.1 |
+---------------+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT version();
+-------------------------+
| version()               |
+-------------------------+
| 5.7.32-0ubuntu0.18.04.1 |
+-------------------------+
1 row in set (0.00 sec)