MYSQL – Detecting Current Version of MySQL Server Installation

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.

MYSQL - Detecting Current Version of MySQL Server Installation version

Reference : Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Weekly Series – Memory Lane – #053 – Final Post in Series
Next Post
SQL SERVER – Implementing IF … THEN in SQL SERVER with CASE Statements

Related Posts

Leave a Reply

Menu