How to find MySQL Server Version - Quick Guide - DevDummy


Views | Thoughts | Concepts | Techniques

Sunday, September 09, 2018

How to find MySQL Server Version - Quick Guide

Is it often required to find the exact MySQL version running in a specific system. Specially it is required to check the version incompatibilities before executing any queries or the scripts on a foreign system. 

Mostly these inconsistencies appear due to the database engine variations. So here is the way to find the version.

MySQL Version Query

SHOW VARIABLES WHERE variable_name = "version";

However to see all the related version information, 


Command Line

mysql -V

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -V

mysql  Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)


No comments:

Post a Comment