• mysql数据库查看版本号


    1.在命令行登录mysql,即可看到mysql的版本号

    [root@mysql02 bin]# ./mysql -uroot -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 10
    Server version: 5.7.29-log MySQL Community Server (GPL)

    Copyright (c) 2000, 2020, 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.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>


    2.利用navicat连接mysql的客户端工具可以查看
    连接之后右键——详细信息


    3.利用mysql命令查看
    mysql> select version();

    +------------+
    | version() |
    +------------+
    | 5.7.29-log |
    +------------+
    1 row in set (0.00 sec)


    4.在命令行使用status查看
    mysql> status
    --------------
    ./mysql Ver 14.14 Distrib 5.7.29, for linux-glibc2.12 (x86_64) using EditLine wrapper

    Connection id: 10
    Current database:
    Current user: root@localhost
    SSL: Not in use
    Current pager: stdout
    Using outfile: ''
    Using delimiter: ;
    Server version: 5.7.29-log MySQL Community Server (GPL)
    Protocol version: 10


    5.使用mysql --help | grep Distrib查看
    [root@mysql02 bin]# ./mysql --help | grep Distrib
    ./mysql Ver 14.14 Distrib 5.7.29, for linux-glibc2.12 (x86_64) using EditLine wrapper

     

  • 相关阅读:
    C#中抽象类和接口的区别
    人机交互复习
    信息安全复习2关于网络安全
    多读书
    致大学:我的最后几次坚持
    腾讯CMEM平台简介
    面向对象中组合和继承的关系
    软件测试笔记
    一个人的独白(两年生活的自省)
    学习之路二十四:2012年我从工作中学会了哪些?
  • 原文地址:https://www.cnblogs.com/zhm1985/p/15875090.html
Copyright © 2020-2023  润新知