Chcek MySQL version in three ways on Win OS

来源:互联网 发布:war3数据库 编辑:程序博客网 时间:2024/05/17 04:14

1. Without login into mysql, type it into your cmd

mysql -V

mysql  Ver 14.14 Distrib 5.1.45, for Win32 (ia32)


2. login mysql

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.1.45, for Win32 (ia32)


Connection id:          1517
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.1.45-community MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 58 min 46 sec


Threads: 25  Questions: 19559  Slow queries: 0  Opens: 222  Flush tables: 1  Ope
n tables: 9  Queries per second avg: 5.547
--------------


3. login mysql

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.1.45-community |
+------------------+
1 row in set (0.07 sec)


原创粉丝点击