Note
- For V4.3.x, this variable was introduced starting from V4.3.5 BP1.
- For other versions of V4.2.x, this variable was introduced starting from V4.2.5 BP1. For V4.2.1, it was introduced starting from V4.2.1 BP10.
Description
The port variable specifies the port number on which the OBServer node listens for TCP/IP connections. It is used during the deployment of the OBServer node.
Applicability
This variable applies only to the MySQL-compatible mode of OceanBase Database.
Privilege requirement
Query variables
Users in the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the values of global system variables.Modify variables
You cannot modify this variable.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 3306 |
| Scope | Global |
| Modifiable | No. You can specify this variable only when deploying the OBServer node, and you cannot modify it by using the SET statement. |
Examples
Query the port number on which the server listens for TCP/IP connections.
obclient> SHOW VARIABLES LIKE 'port';
The query result is as follows:
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 2881 |
+---------------+-------+
1 row in set