如何查看MySQL软件版本信息(2)

7.mysqladmin 命令方式
[root@linuxidc ~]#  mysqladmin -uroot -p -hlocalhost version;
 Enter password:
 mysqladmin  Ver 8.42 Distrib 5.6.22, for Linux on x86_64
 Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
 affiliates. Other names may be trademarks of their respective
 owners.

Server version          5.6.22-enterprise-commercial-advanced
 Protocol version        10
 Connection              Localhost via UNIX socket
 UNIX socket            /var/lib/mysql/mysql.sock
 Uptime:                46 days 7 min 45 sec

Threads: 1  Questions: 133  Slow queries: 0  Opens: 48  Flush tables: 1  Open tables: 41  Queries per second avg: 0.000

三、官方说明  2.1.1章节
The naming scheme in MySQL 5.6 uses release names that consist of three numbers and a suffix; for example, mysql-5.6.1-m1. The numbers within the release name are interpreted as follows:
 The first number (5) is the major version and describes the file format. All MySQL 5 releases have the same file format.
 The second number (6) is the release level. Taken together, the major version and release level constitute the release series number.
 The third number (1) is the version number within the release series. This is incremented for each new release. Usually you want the latest version for the series you have chosen.

四、总结:
    看似简单的工作,如果没有接触过人还真是不晓得。所以DBA的大小朋友们,把你不会的东西提早学习一下,会受益匪浅的。想起来一句话(书到用时方恨少;事非经过不知难。)译:知识总是在运用时才让人感到太不够了,许多事情如果不亲身经历过就不知道它有多难。

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/fe365bda70bb700b223d9066c34df42e.html