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)

....