MYSQL – Detecting Current Version of MySQL Server Installation

Posted by Pinal Dave on SQL Authority See other posts from SQL Authority or by Pinal Dave
Published on Sun, 03 Nov 2013 01:30:48 +0000 Indexed on 2013/11/03 4:00 UTC
Read the original article Hit count: 301

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

© SQL Authority or respective owner

Related posts about mysql

Related posts about PostADay