查询mysql版本信息

最新推荐文章于 2023-02-14 22:01:57 发布

windone0109

最新推荐文章于 2023-02-14 22:01:57 发布

阅读量2.5k

点赞数

分类专栏： DataBase 文章标签： mysql socket unix server ssl 终端

本文链接：https://blog.csdn.net/windone0109/article/details/5748608

版权

DataBase 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

1：在终端下：mysql -v

[root]$ mysql -V
mysql Distrib 5.1.33, for redhat-linux-gnu (i686)

2：在mysql中：mysql status;

>mysql status;
--------------
mysql Distrib 5.1.33, for redhat-linux-gnu (i686)

Connection id          416
SSL                    Not in use
Current pager          stdout
Using outfile          ''
Using delimiter        ;
Server version         5.1.33
Protocol version       10
Connection             Localhost via UNIX socket
Client characterset    latin1
Server characterset    latin1
UNIX socket            tmpmysql_3311.sock
Uptime                 62 days 21 hours 21 min 57 sec

Threads 1 Questions 584402560 Slow queries 424 Opens 59664208 Flush tables 1 Open tables 64 Queries per second avg 107.551

3：在help里面查找

[root]$ mysql --help | grep Distrib
mysql Distrib 5.1.33, for redhat-linux-gnu (i686)

4：使用mysql的函数

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