How to tell what version of MySQL® or MariaDB that is running

Introduction

If you need to know the version of MySQL or MariaDB is running on the server, below is a quick guide to see what the version is.

Procedure

1. Log into your server via SSH as 'root'. Or through the WHM: Terminal feature.

2. Run the following command:

mysqladmin version

3. Observe the output.

MySQL:

# mysqladmin version
mysqladmin Ver 8.42 Distrib 5.7.31, for Linux on x86_64
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version 5.7.31
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 14 days 23 hours 42 min 56 sec


Threads: 1 Questions: 23338 Slow queries: 0 Opens: 12744 Flush tables: 1 Open tables: 2000 Queries per second avg: 0.018

MariaDB:

# mysqladmin version
mysqladmin Ver 9.1 Distrib 10.3.24-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version 10.3.24-MariaDB
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 sec


Threads: 7 Questions: 4 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 0.571

That's it.