MySQL version

How to know MySQL server version.

There is a special MySQL function VERSION() which returns current server version:

<pre><code>SELECT VERSION();

1	<pre><code>SELECT VERSION();

Also, it is possible to determine version using global/session variables, e.g.:

<pre><code>SELECT * FROM
  INORMATION_SCHEMA.GLOBAL_VARIABLES
WHERE
 VARIABLE_NAME LIKE '%version%';

<pre><code>SELECT * FROM

INORMATION_SCHEMA.GLOBAL_VARIABLES

WHERE

VARIABLE_NAME LIKE '%version%';