Check MySQL Version

access_time 19 days ago visibility6 comment 0

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

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to publish your article on Kontext?

Learn more

More from Kontext

visibility 6
thumb_up 0
access_time 19 days ago

Checking MySQL version can be done easily via mysql CLI or using SQL. $ mysql -V mysql Ver 14.14 Distrib 5.7.32, for Linux (x86_64) using EditLine wrapper We can either get it from database server variables or using version() function. mysql> show variables LIKE ...

Apache Hive 3.1.2 Installation on Linux Guide
visibility 83
thumb_up 0
access_time 19 days ago

On this page I'm going to show you how to install the latest version Apache Hive 3.1.2 on Windows 10 using Windows Subsystem for Linux (WSL) Ubuntu distro.  You can follow these instructions to install Apache Hive 3.1.2  on any UNIX-alike systems incl. Debian, Ubuntu, openSUSE, Red Hat ...

visibility 6
thumb_up 0
access_time 19 days ago

The following code snippet creates a user named 'hive' with password ('hive') that never expires. CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive' password expire never; The following SQL statement grants all permission to user 'hive': GRANT ALL ON *.* TO 'hive'@'localhost';