query to get mysql version code example

Example 1: mysql version

# console
mysql --version
mysql -V

# sql query
SHOW VARIABLES LIKE ‘%version%’;

Example 2: how to get current mysql version

SELECT VERSION ();

Example 3: what is my mysql version

Mysql version
mysql -V

Example 4: mysql version

mysqld --version