1、在终端下:mysql -V。 以下是代码片段:
[leen@login ~]$ mysql -V
--------------
mysql Ver 14.14 Distrib 5.5.40, for Win32 (x86)
2、在mysql中:mysql> status;
mysql> status;
--------------
D:\phpStudy\mysql\bin\mysql.exe Ver 14.14 Distrib 5.5.40, for Win32 (x86)
Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.5.40 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: gbk
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 48 min 21 sec
Threads: 1 Questions: 1518 Slow queries: 0 Opens: 47 Flush tables: 1 Open tables: 0 Queries per second avg: 0.523
--------------
3、在help里面查找:
[leen@login ~]$ mysql --help | grep Distrib
mysql Ver 14.14 Distrib 5.5.40, for Win32 (x86)
4、使用mysql的函数:
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.40 |
+-----------+
1 row in set (0.02 sec)
Author:leedaning
本文地址:http://blog.csdn.net/leedaning/article/details/51542995