MYSQL – Identifying Current Version of MySQL Server Installation – Part 2

Earlier I wrote an article about Detecting Current Version of MySQL Server Installation. After the post quite a few emails I received where various users suggested that there are many more ways to figure out the version of MySQL. Here are few of the methods which I received in the email.

Method 1:

This method retrieves value with the help of Information Functions.

SELECT VERSION();

MYSQL - Identifying Current Version of MySQL Server Installation - Part 2 mysqlversion2

Method 2:

This method is very similar to SQL Server.

SELECT @@Version

MYSQL - Identifying Current Version of MySQL Server Installation - Part 2 mysqlversion1

Method 3:

You can connect to MySQL with command prompt and type following command:

STATUS;

MYSQL - Identifying Current Version of MySQL Server Installation - Part 2 mysqlversion3

Method 4:

Please refer my earlier blog post.

SHOW VARIABLES LIKE "%version%";

MYSQL - Identifying Current Version of MySQL Server Installation - Part 2 version

Let me know if you know any more method and I will extend this blog post.

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

Solarwinds
,
Previous Post
MySQL – How to Find mysqld.exe with Command Prompt – Fix: ‘mysql’ is not recognized as an internal or external command, operable program or batch file
Next Post
Personal Technology – Laptop Screen Blank – No Post – No BIOS – No Boot

Related Posts

1 Comment. Leave new

  • Nigel Clayforth
    November 12, 2013 4:09 pm

    Curious results when using:
    SELECT @@VERSION AS [SQL Version Info];

    SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

    Option one returns info that suggest we are on SP2 – whereas the second option returns the correct SP (4)

    Reply

Leave a Reply

Menu