Four ways to view MySQL version
1: Under the terminal: Mysql-v. Here is the code snippet:
[Email protected] ~]$ mysql-v
MySQL Ver 14.7 distrib 4.1.10a, for Redhat-linux-gnu (i686)
2::mysql> status in MySQL;
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