How to check MySQL version in Windows

In this post I will show you different ways to get the version of currently installed MySQL in your machine.

-Using mysqladmin, run the below command (highlighted in red) in cmd

D:\>mysqladmin -u root -p version

-using MySQL client

-Using MySQL service properties (path in service properties in taken installation directory).

-Using MySQL version query

Select @@version (or) Select version()

 

Cheers,
Naveen