Check MySQL Version

visibility 93 access_time 2 years ago languageEnglish timeline Stats
timeline Stats
Page index 0.17
more_horiz

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)
copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext
Apache Hive 3.1.2 Installation on Linux Guide
visibility 6,001
thumb_up 3
access_time 15 days ago
Apache Hive 3.1.2 Installation on Linux Guide
Python: Load Data from MySQL
visibility 391
thumb_up 0
access_time 2 years ago