Finding MySQL Server version

Problem: How to find version of MySQL server.
Solution: You can find out version information using version variables. 

Login to mysql server and fire the below statement
 

 
mysql> SHOW VARIABLES LIKE "%version%";

Sample Result:

 
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.1.52              |
| version_comment         | Source distribution |
| version_compile_machine | x86_64              |
| version_compile_os      | redhat-linux-gnu    |
+-------------------------+---------------------+