How to find MySQL Server Version - Quick Guide - DevDummy

Latest

Guildes | 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, 

SHOW VARIABLES LIKE "%version";


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