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 mode.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL 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)