bitscn.com
mysql查看版本号的五种方式
查看版本信息
#1 
使用命令行模式进入mysql会看到最开始的提示符 
your mysql connection id is 3
server version: 5.1.69 source distribution
    #2
命令行中使用status可以看到
[sql] 
mysql> status;  
--------------  
mysql  ver 14.14 distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1
connection id:3  
current database:  
current user: root@localhost  
ssl: not in use  
current pager:stdout  
using outfile:''  
using delimiter:;  
server version:5.1.69 source distribution  
protocol version:10  
connection: localhost via unix socket  
server characterset:utf8  
db     characterset:utf8  
client characterset:utf8  
conn.  characterset:utf8  
unix socket: /var/lib/mysql/mysql.sock  
uptime: 3 days 14 hours 50 sec
threads: 1  questions: 5  slow queries: 0  opens: 15  flush tables: 1  open tables: 8  queries per second avg: 0.0  
--------------
#3 使用系统函数
[sql] 
mysql> select version();  
+-----------+  
| version() |  
+-----------+  
| 5.1.69    |  
+-----------+  
1 row in set (0.12 sec)
#4 $  mysql --help | grep distrib
mysql  ver 14.14 distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1
#5 包管理工具（根据不同系统 rh系列或则是bsd系列）
$ rpm -qa|grep mysql
qt-mysql-4.6.2-20.el6.x86_64
mysql-server-5.1.69-1.el6_4.x86_64
mysql-libs-5.1.69-1.el6_4.x86_64
mysql-5.1.69-1.el6_4.x86_64
mysql-devel-5.1.69-1.el6_4.x86_64
bitscn.com