query version mysql code example

Example 1: mysql version

# console
mysql --version
mysql -V

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

Example 2: what is my mysql version

Mysql version
mysql -V