First, using the command line mode to enter MySQL will see the first prompt, second, the command line using status can be seen; third, use system functions and so on, view version information
#1使用命令行模式进入mysql会看到最开始的提示符
Your MySQL Connection ID is 3
Server version:5.1.69 Source Distribution
#2命令行中使用status可以看到
The 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
#3 using System functions
The 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
Ref:www.cnblogs.com/end/archive/2011/10/18/2216461.html
View MySQL version number (the simplest is status)
