MySql数据库版本查询

最新推荐文章于 2024-08-12 03:11:23 发布

duanzongbin

最新推荐文章于 2024-08-12 03:11:23 发布

阅读量1w

点赞数

分类专栏： MySql数据库文章标签： mysql 数据库 database server user tcp

MySql数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

MySql版本信息的查询：

1、通过mysql -V命令查询

C:/mysql/bin>mysql -V
mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

2、通过mysql模式下的status命令查看状态

mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

Connection id:          14933
Current database:       mysql
Current user:           root@localhost
SSL:                    Not in use
Server version:         4.0.18-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 19 hours 24 min 41 sec

Threads: 2 Questions: 37443 Slow queries: 0 Opens: 355 Flush tables: 1 Open
tables: 9 Queries per second avg: 0.536
--------------

mysql>

3、通过mysql模式下的select语句查询

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

mysql>

4、通过mysql --help命令进行查看

C:/mysql/bin>mysql --help
mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
Copyright (C) 2002 MySQL AB

......

转帖：http://www.hackbase.com/tech/2009-06-25/53429.html