1: Under the terminal: Mysql-v. The following is a code fragment:
Copy Code code as follows:
[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:
Copy Code code as follows:
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:
Copy Code code as follows:
[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:
Copy Code code as follows:
Mysql> select version ();
+-------------+
| Version () |
+-------------+
| 3.23.56-log |
+-------------+
1 row in Set (0.00 sec)