how to know the version of mysql 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: mysql version

mysqld --version