【产品名称】
3.1.3-OceanBase CE
【产品版本】
[admin@localhost ~]$ obclient --version
obclient Ver 15.1 Distrib 10.4.18-MariaDB, for Linux (x86_64) using readline 5.1
OceanBase 3.1.3
【问题描述】
[admin@localhost ~]$ obclient -h127.0.0.1 -uroot@my_tenant -P2881 -p’root123’ -c -A test Welcome to the OceanBase. Commands end with ; or \g. Your MySQL connection id is 3221490143 Server version: 5.7.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. MySQL [test]> \q Bye [admin@localhost ~]$ obclient -h127.0.0.1 -uroot@my_tenant -P2883 -p’root123’ -c -A test Welcome to the OceanBase. Commands end with ; or \g. Your MySQL connection id is 25 Server version: 5.6.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. 使用obclient和mysql连接不同端口,而显示的server version不同,是什么原因导致? 连接2881端口显示Server version: 5.7.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) MySQL [information_schema]> select version(); ±-------------------+ | version() | ±-------------------+ | 3.1.3-OceanBase CE | ±-------------------+ 1 row in set (0.001 sec) MySQL [information_schema]> show variables like ‘%version%’; ±------------------------±-----------------------------------------------------------------------------------------------------------+ | Variable_name | Value | ±------------------------±-----------------------------------------------------------------------------------------------------------+ | ob_last_schema_version | 0 | | protocol_version | 10 | | tls_version | | | version | 3.1.3-OceanBase CE | | version_comment | OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) | | version_compile_machine | | | version_compile_os | | ±------------------------±-----------------------------------------------------------------------------------------------------------+ 连接2883端口显示Server version: 5.6.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) MySQL [test]> select version(); ±-------------------+ | version() | ±-------------------+ | 3.1.3-OceanBase CE | ±-------------------+ 1 row in set (0.003 sec) MySQL [test]> show variables like ‘%version%’; ±------------------------±-----------------------------------------------------------------------------------------------------------+ | Variable_name | Value | ±------------------------±-----------------------------------------------------------------------------------------------------------+ | ob_last_schema_version | 0 | | protocol_version | 10 | | tls_version | | | version | 3.1.3-OceanBase CE | | version_comment | OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) | | version_compile_machine | | | version_compile_os | | ±------------------------±-----------------------------------------------------------------------------------------------------------+ 7 rows in set (0.005 sec)