Check MySQL Version

visibility 87 access_time 2 years ago languageEnglish timeline Stats
timeline Stats
Page index 0.17

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext
Connect to MySQL in .NET 5
visibility 2,771
thumb_up 1
access_time 2 years ago
Create Pandas DataFrame from MySQL
visibility 121
thumb_up 0
access_time 2 years ago
Spark Scala: Load Data from MySQL
visibility 1,494
thumb_up 0
access_time 2 years ago
Spark Scala: Load Data from MySQL