Note
- For V4.3.x, this variable is available starting with V4.3.5 BP1.
- For V4.2.x other versions, 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 the server to listen for TCP/IP connections when you deploy an OBServer node.
Applicability
This variable is available only in MySQL-compatible mode of OceanBase Database.
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
This variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 3306 |
| Scope | Global |
| Modifiable | No. This variable can be specified only when you deploy an OBServer node and cannot be modified by executing the SET statement. |
| Read-only | Yes |
Examples
Query the port number for the server to listen for 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)