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.


Method 2:

This method is very similar to SQL Server.

SELECT @@Version

Method 3:

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


Method 4:

Please refer my earlier blog post.


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

Reference : Pinal Dave (

MySQL, SQL Scripts
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)


Leave a Reply

Exit mobile version