Mysql：查看Mysql版本号
- 方法一**【推荐】**：
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.15 |
+-----------+
1 row in set (0.00 sec)
- 方法二：
mysql> status
--------------
mysql Ver 8.0.15 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
Connection id: 613
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.15 MySQL Community Server - GPL
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /tmp/mysql.sock
Uptime: 5 days 8 hours 37 min 21 sec
Threads: 37 Questions: 6324 Slow queries: 15 Opens: 757 Flush tables: 3 Open tables: 411 Queries per second avg: 0.013
--------------
- 方法三：
mysql> s
--------------
mysql Ver 8.0.15 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
Connection id: 613
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.15 MySQL Community Server - GPL
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /tmp/mysql.sock
Uptime: 5 days 8 hours 37 min 45 sec
Threads: 37 Questions: 6327 Slow queries: 15 Opens: 757 Flush tables: 3 Open tables: 411 Queries per second avg: 0.013
--------------
- 方法四：
mysql> show variables like "%version%";
+--------------------------------------------------+------------------------------+
| Variable_name | Value |
+--------------------------------------------------+------------------------------+
| group_replication_allow_local_lower_version_join | OFF |
| immediate_server_version | 999999 |
| innodb_version | 8.0.15 |
| original_server_version | 999999 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1,TLSv1.1,TLSv1.2 |
| version | 8.0.15 |
| version_comment | MySQL Community Server - GPL |
| version_compile_machine | x86_64 |
| version_compile_os | linux-glibc2.12 |
| version_compile_zlib | 1.2.11 |
+--------------------------------------------------+------------------------------+
12 rows in set (0.00 sec)
- 更多学习方法 点击我
- 方法五：
$ mysql -V
mysql Ver 8.0.15 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/5512.html
