chk mysql server version


//=== http://stackoverflow.com/questions/8987679/how-to-know-the-version-of-the-mysql-database

[Q] how to chk mysql server version on ubuntu?

$ mysql --version
$ dpkg -l 'mysql-server*'


//=== after login mysql server

mysql> SELECT VERSION();
mysql> SHOW VARIABLES LIKE "%version%";


* RDS
mysql> show variables like '%version%';

+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.6.19 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.19-log |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)



*ec2
mysql> SHOW VARIABLES LIKE "%version%";

+-------------------------+-------------------------+
| Variable_name | Value |
+-------------------------+-------------------------+
| innodb_version | 5.5.41 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.41-0ubuntu0.14.04.1 |
| version_comment | (Ubuntu) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+-------------------------+
7 rows in set (0.00 sec)