1: In the terminal: mysql-v. The following is a code snippet:
[Shengting @ login ~] $ Mysql-V
MySQL Verver 14.7 distrib 4.1.10a, for Redhat-Linux-GNU (i686)
2: in MySQL: mysql> status;
The following is a code snippet:
Mysql> status;
--------------
MySQL Verver 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 days 21 hours 21 min 57 sec
Threads: 1 questions: 584402560 slow queries: 424 opens: 59664208 flush tables: 1 open tables: 64 queries per second AVG: 107.551
3: search
The following is a code snippet:
[Shengting @ login ~] $ Mysql -- help | grep distrib
MySQL Verver 14.7 distrib 4.1.10a, for Redhat-Linux-GNU (i686)
4: Use MySQL Functions
The following is a code snippet:
Mysql> select version ();
+ ------------- +
| Version () |
+ ------------- +
| 3.23.56-log |
+ ------------- +
1 row in SET (0.00 Sec)