[MySQL] five ways to view the version number

View version information
#1

Enter MySql in command line mode and you will see the start prompt.
Your MySQL connection ID is 3
Server version: 5.1.69 Source Distribution
#2

You can see the status in the command line.

mysql> status;--------------mysql  Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1Connection id:3Current database:Current user: root@localhostSSL: Not in useCurrent pager:stdoutUsing outfile:''Using delimiter:;Server version:5.1.69 Source distributionProtocol version:10Connection: Localhost via UNIX socketServer characterset:utf8Db     characterset:utf8Client characterset:utf8Conn.  characterset:utf8UNIX socket: /var/lib/mysql/mysql.sockUptime: 3 days 14 hours 50 secThreads: 1  Questions: 5  Slow queries: 0  Opens: 15  Flush tables: 1  Open tables: 8  Queries per second avg: 0.0--------------

#3 Use System Functions

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 (RH series or BSD series based on different systems)

$ 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

Ref: www.cnblogs.com/end/archive/2011/10/18/2216461.html