MySQL view version number of five ways to introduce

First, using the command line mode into MySQL will see the first prompt;

View version Information
#1使用命令行模式进入mysql会看到最开始的提示符
Your MySQL Connection ID is 3
Server version:5.1.69 Source Distribution

Second, the command line using status can be seen;
#2命令行中使用status可以看到

Copy CodeThe code is as follows:
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: [email protected]
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 Sockets:/var/lib/mysql/mysql.sock
Uptime:3 Days Hours sec
Threads:1 questions:5 Slow queries:0 opens:15 Flush tables:1 Open tables:8 queries per second avg:0.0

Third, the use of system functions and so on, interested friends can refer to the next ha
#3 using System functions

Copy CodeThe code is as follows:
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 Package Management tools (depending on the system RH series or BSD series)
$ 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

MySQL view version number of five ways to introduce