Find Your MySQL Version on Windows - Quick Guide

The MySQL version helps identify compatibility requirements when troubleshooting a database on Windows. Check the running server’s version, because the installed client or package may have a different version.

Check the connected server

1. Open MySQL Workbench and connect to the intended server, or sign in through the MySQL command-line client.

2. Run:

   SELECT VERSION();

3. Record the result and confirm which server you connected to, particularly if you manage more than one instance.

Check the installed client

In Command Prompt, run:

mysql --version

If Windows cannot find the command, open the bin directory of the relevant MySQL installation first. The path depends on where that version was installed.

This command reports the client executable’s version. Programs and Features may show an installed package version, but neither result confirms the version of a remote server or a different running instance.