SQL

mysql version

# Console:
mysql -V
mysql --version
# Query:
SHOW VARIABLES LIKE "%version%";
# PHPMyAdmin Interface, on the right side:
> Database server > Server version

what is my mysql version

Mysql version
mysql -V

mysql version query

SHOW VARIABLES LIKE ‘%version%’;

mysql version

mysqld --version

mysql version

mysqladmin version
 - or -
mysqladmin ve

## Example Output
mysqladmin  Ver 9.1 Distrib 10.3.36-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.3.36-MariaDB-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 22 hours 40 sec

Threads: 8  Questions: 271157  Slow queries: 0  Opens: 272  Flush tables: 1  Open tables: 264  Queries per second avg: 3.421

mysql --version

mysql  Ver 15.1 Distrib 10.5.15-MariaDB, for debian-linux-gnueabihf (armv8l) using  EditLine wrapper