MYSQL – Detecting Current Version of MySQL Server Installation
- by Pinal Dave
Here is one of the most popular questions which I receive which is related to MySQL installation. The question is how do I know which version of the MySQL I have installed on my server. Here is the simple trick which works all the time. Connect to your MySQL engine with the help of Command Prompt or MySQL Workbench. When you execute the following command it will give us all the necessary information related to MySQL Version.
SHOW VARIABLES LIKE "%version%";
Here is the screenshot of the result which I receive when I ran above command on my Test Server.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Filed under: MySQL, PostADay, SQL, SQL Authority, SQL Query, SQL Tips and Tricks, T SQL