Raymond Raymond

Check MySQL Database Version

event 2020-12-28 visibility 157 comment 0 insights toc
more_vert
insights Stats
toc Table of contents

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)
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts