Note
- For V4.3.x, this variable is available starting with V4.3.5 BP1.
- For V4.2.x, this variable is available starting with V4.2.5 BP1. For V4.2.1, this variable is available starting with V4.2.1 BP10.
Description
port specifies the port number for listening to TCP/IP connections when an OBServer node is deployed.
Applicability
This variable is applicable only to OceanBase Database in MySQL-compatible mode.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of a Global system variable.Modify variables
You cannot modify this variable.
Attributes
Attribute |
Description |
|---|---|
| Type | Int |
| Default value | 3306 |
| Scope | Global |
| Modifiable | No. This variable can be specified only when an OBServer node is deployed. You cannot execute the SET statement to modify the value. |
| Read-only | Yes |
Examples
Query the port number for listening to TCP/IP connections.
obclient> SHOW VARIABLES LIKE 'port';
The query result is as follows:
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 2881 |
+---------------+-------+
1 row in set (0.003 sec)