How to check MySQL version?


In this new knowledgebase, I will explain on how you can check MySQL version number.  There are plenty ways you can check, however I would like to share the simple steps to verify the MySQL version.

For your information, MySQL provides some features for particular version numbers and on particular platforms only.
So, in some situations it gets really important to find the MySQL version number installed.

1. Run simple command(only for Linux server/devices)
mysql -V
mysql Ver 15.1 Distrib 5.5.41-MariaDB, for Linux (x86_64) using readline 5.1


2. Check via phpmyadmin
You may check it by login to phpmyadmin page. Click on home icon on the top-left corner of any page and at the very top. You should see MySQL server’s version number on the right side of the page (something like the image below).


OR

Run SQL command in phpmyadmin by key in below command and click Go
SELECT @@version;


Comments