0 环境信息

• 操作系统：Linux version 3.10.0-957.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Thu Nov 8 23:39:32 UTC 2018
• MySQL: Docker部署，Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

1 命令行查看mysql -V

$ mysql -V
mysql  Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

2 命令行查看mysql --version

$ mysql --version
mysql  Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

3 命令行查看筛选

$ mysql --help | grep "Ver "
mysql  Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

4 SQL语句select version()

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.28    |
+-----------+
1 row in set (0.00 sec)

5 SQL语句status或者\s

mysql> status
--------------
mysql  Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:          620
Current database:
Current user:           root@172.17.0.4
SSL:                    Cipher in use is TLS_AES_256_GCM_SHA384
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         8.0.28 MySQL Community Server - GPL
Protocol version:       10
Connection:             172.17.0.2 via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Binary data as:         Hexadecimal
Uptime:                 390 days 23 hours 24 min 14 sec

Threads: 2  Questions: 1522  Slow queries: 0  Opens: 518  Flush tables: 3  Open tables: 437  Queries per second avg: 0.000
--------------

6 mysql客户端连接mysql server的时候显示版本信息

$ docker run -it --rm mysql mysql -h172.17.0.2 -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 620
Server version: 8.0.28 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.