Four ways to view MySQL version

1: Under the terminal:mysql-v. Here is the code snippet:

$ mysql-v

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

2: In MySQL:mysql> status;

Here is the code snippet:

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 Sockets:/tmp/mysql_3311.sock

Uptime:62 Days Hours min sec

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

3: Find in Help

Here is the code snippet:

[Email protected] ~]$ mysql--help | grep distrib

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

4: Using MySQL's functions

Here is the code snippet:

mysql> Select version ();

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

| Version () |

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

| 3.23.56-log |

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

1 row in Set (0.00 sec)

Four ways to view MySQL version