mysql version query

1# console
2mysql --version
3mysql -V
4
5# sql query
6SHOW VARIABLES LIKE ‘%version%’;

1SHOW VARIABLES LIKE "%version%";
2+-------------------------+------------------------------------------+
3| Variable_name           | Value                                    |
4+-------------------------+------------------------------------------+
5| protocol_version        | 10                                       |
6| version                 | 5.0.27-standard                          |
7| version_comment         | MySQL Community Edition - Standard (GPL) |
8| version_compile_machine | i686                                     |
9| version_compile_os      | pc-linux-gnu                             |
10+-------------------------+------------------------------------------+
115 rows in set (0.04 sec)

1Mysql version
2mysql -V

1# Console:
2mysql -V
3mysql --version
4# Query:
5SHOW VARIABLES LIKE "%version%";
6# PHPMyAdmin Interface, on the right side:
7> Database server > Server version

1SHOW VARIABLES LIKE ‘%version%’;

1mysqld --version