How to Check MySQL Version of Server (3 Quick Ways)

Do you want to check MySQL Version of a server?

In this article, I will tell you how to check the MySQL version of a server. If the MySQL is installed on Windows or Linux, these tips would work.

What is MySQL?

SQL is the most popular language for the database content. It is used to access, manage, and add the content to the database. SQL is very reliable and quick to process the database.

MySQL is a free open source relational database management system that uses SQL (structured query language). It is a necessary part of almost every open source PHP tools. A few of the examples of PHP & MySQL-based scripts are WordPress, Joomla, Magento, and Drupal.

MySQL Version

The latest version of MySQL is 8.0.19, released on 13 January 2020. However, there is still support of version 5.6.45, but it will end soon. 

Using the outdated version of MySQl that does not have any support is not smart. Do update your MySQL version to the more advanced and quick versions.

Ways to Check MySQL Version

You can check the version of the MySQL from the back end and the PHP Admin.

1. From the Command Line
2. Checking the MySQL Client
3. From the phpMyAdmin Interface

#1 From the Command Line

1. Open the command line and enter this command:

mysql -V

The response would be this:

#2 From the MySQL Client

When you run the MySQL command client without any flags, the version will be displayed. So while logged in via SSH enter:

If there are no flags and you are running MySQL command client, it will show the version of MySQL. 

1. Log in via SSH Server and Enter

2. However, you can also run a simple command to find out more.

SHOW VARIABLES LIKE "%version%"

A table would appear, where you can learn additional detail about the installed MySQL on the server.

#3 Check MySQL Version From phpMyAdmin Interface

If you don’t have access to the server via SSH, you do not need to worry. You can check the MySQL version of the server from phpMyAdmin too.

PHP admin is a free and open-source tool to manage and maintain MySQL. It is written in PHP and offers an interface that makes it easy to make changes in the DBMS. PHP admin is a prevalent tool, and the majority of the hosting panel offers the phpMy Admin to the users.

Login into your hosting account, and open up the PHP Admin.

On the right side, you will find the information about the database server.

In that box, you will find the version of the MySQL installed on the Linux server.

If you encounter any problem, do let us know in the comment box.