MySQL版本查看

2019独角兽企业重金招聘Python工程师标准>>>

查看MySQL版本信息，可通过下列几种方法：

    方法一：mysql -V

        命令行窗口下执行mysql -V命令，返回结果如下：

            mysql  Ver 14.14 Distrib 5.5.28, for Win64 (x86)

    方法二：mysql --help

        命令行窗口下执行【mysql --help | grep/findstr Distrib】,结果如下：

            mysql  Ver 14.14 Distrib 5.5.28, for Win64 (x86)

    方法三：status命令

        登录到mysql中，执行【status;】命令，返回结果如下：

            --------------

            mysql  Ver 14.14 Distrib 5.5.28, for Win64 (x86)

            Connection id:          2

            Current database:

            Current user:           root@localhost

            SSL:                    Not in use

            Using delimiter:        ;

            Server version:         5.5.28-log 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:                 3 min 4 sec

            Threads: 1  Questions: 4  Slow queries: 0  Opens: 33  Flush tables: 1  Open tables: 26  Queries per second avg: 0.021

            --------------

    方法四：mysql提供的version()函数

        登录mysql后，执行【select version();】，返回结果如下：   

        +------------+

        | version()  |

        +------------+

        | 5.5.28-log |

        +------------+

转载于:https://my.oschina.net/u/1251536/blog/352331