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.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

One thought on “MYSQL – Detecting Current Version of MySQL Server Installation

  1. Pingback: MYSQL – Identifying Current Version of MySQL Server Installation – Part 2 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s