Four ways to view the MySQL version

Rookie Lecture: Four ways to view the MySQL version

1: Under the terminal: Mysql-v. The following is a code fragment:

[Shengting@login ~]$ Mysql-v

MySQL Ver 14.7 distrib 4.1.10a, for Redhat-linux-gnu (i686)

2::mysql> status in MySQL;

The following is a code fragment:

mysql> status;

--------------

MySQL Ver 14.7 distrib 4.1.10a, for Redhat-linux-gnu (i686)

Connection id:416

Ssl:not in use

Current Pager:stdout

Using outfile: '

Using delimiter:;

Server Version:3.23.56-log

Protocol version:10

Connection:localhost via UNIX socket

Client characterset:latin1

Server characterset:latin1

UNIX Socket:/tmp/mysql_3311.sock

Uptime:62 hours sec

Threads:1 questions:584402560 Slow queries:424 opens:59664208 Flush tables:1 Open tables:64 queries per second avg: 107.551

3: Find inside Help

The following is a code fragment:

[Shengting@login ~]$ mysql--help grep distrib

MySQL Ver 14.7 distrib 4.1.10a, for Redhat-linux-gnu (i686)

4: Using the MySQL function

The following is a code fragment:

Mysql> select version ();

+-------------+

Version ()

+-------------+

3.23.56-log

+-------------+

1 row in Set (0.00 sec)