查询mysql版本信息

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)