How To Find MySQL Server Version

If you’re not sure which version of MySQL installed on your server, there are multiple ways to find the MySQL server version number. Also, you can ask your hosting provider, I guess this is the easiest and simplest way! I’ll show you a couple of ways in this article. Let’s explore different ways to check the MySQL version installed on your server.

Using phpMyAdmin:

If your server has PHPMyAdmin script installed to manage your MySQL database, then you’ll have access to all MySQL details through phpMyAdmin tool GUI. Login into your phpMyAdmin admin panel and check the Database Server section on the top right corner.

Using Command Line Tool:

If you don’t have PHPMyAdmin installed on your server, then you can use this method to know the MySQL server information. Open your terminal and run the command below:

mysql --version

You’ll see something like this:

mysql Ver 14.14 Distrib 5.7.16, for osx10.12 (x86_64) using EditLine wrapper

Here 5.7.16 is the MySQL version.