Different Ways to Check MySQL version in cPanel or Linux

Different Ways to Check MySQL version in cPanel or Linux

By far MySQL is the most popular Relational database management system and knowing which MySQL version you are running can be important in some situations.

Here are different ways to check the version of the MySQL server installed on your WHM/ cPanel (or any Linux)

From cPanel “Server information”

Log into your cPanel account and on the right side of the cPanel click the “Server Information” link

server information cpanel

A new page will load where you can see a lot of details about your web hosting account, like Apache, PHP, MySQL, PERL, cPanel versions; server load, the status of the server services.

mysql version on cpanel

From The PHPMyAdmin Interface

In PHPMyAdmin on the right side, under the “Database server” section you will see the “Server version” which is the current  MySQL or MariaDB version running on your server.

mysql version in phpmyadmin

From the command line

If you have SSH access to the server, here are several commands that can help to find the version of your MySQL.

mysqld -V
mysql -v

From the MySQL Client

mysql
mysql client

SHOW VARIABLES LIKE Statement

You can also run the following command for more details, like protocol version and InnoDB version:

SHOW VARIABLES LIKE "%version%";
mysql SHOW VARIABLES LIKE statement

STATUS Command

status command displays the version as well as the uptime of the MySQL server and other useful information.

mysql> status
mysql status command
Written by
Stefan Pejcic
Join the discussion

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.

Categories