MySQL查看版本的方法

最新推荐文章于 2024-05-24 22:43:08 发布

puregold1124

最新推荐文章于 2024-05-24 22:43:08 发布

阅读量487

点赞数

分类专栏： mysql version 文章标签： mysql database select linux

本文链接：https://blog.csdn.net/puregold1124/article/details/41276745

版权

mysql version 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

mysql -V

适用场景：系统中配置了MySQL的环境变量

显示内容：

mysql Ver 14.14 Distrib 5.5.37, for Win64 (x86)

2. mysql -u username -p

适用场景：系统中配置了MySQL的环境变量

显示内容：

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.37 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

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.

3. status

适用场景：登录MySQL账户后

显示内容：

mysql Ver 14.14 Distrib 5.5.37, for Win64 (x86)

Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.5.37 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 19 min 30 sec

4. SELECT version();

适用场景：登陆MySQL账户后

显示内容：

+-----------+
| version() |
+-----------+
| 5.5.37 |
+-----------+

5. mysql --help | grep Distrib

适用场景：Linux环境下，console里直接输入

显示内容：

msql Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline 5.2