Which version is my MySQL Server?

Question

What's the query syntax to determine the exact version number of the MySQL server software?

Answer 1

You can use SHOW VARIABLES:

SHOW VARIABLES WHERE Variable_name = 'version';

Answer 2

select version();

Answer 3

Command line:

mysql --version