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

Howto Check MySQL Version

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.

From the Command Line

  1. Open the command line and enter this command:
mysql -V

The response would be this:

mysql checker check mysql version

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
check mysql version2 check mysql version

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.

mysql version checker

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.

check mysql version1 check mysql version

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.

Latest Magento Tips, Guides, & News

Stay updated with new stuff in the Magento ecosystem including exclusive deals, how-to articles, new modules, and more. 100% Magento Goodness, a promise!

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top

We can help you. Right now.

Fast growing merchants depend ServerGuy for high-performance hosting. Experience counts. Let's get started.

Talk to a sales representative

USA / Worldwide

+1.714.2425683

India

+91.9852704704