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)
【产品名称】
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 【问题描述】