If you’re not sure which version of MySQL is 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. Warning! If the MySQL version is not met the minimum requirement to install the script please upgrade the MySQL server before you install the script to avoid unwanted issues.