Five ways to view Mysql version

View version information
#1 Enter mysql in command line mode and you will see the initial prompt
Your MySQL connection id is 3
Server version: 5.1.69 Source distribution

#2 You can see the status in the command line.
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: 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. 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 Use 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 (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