Note
- For V4.3.x, this variable is available starting with V4.3.5 BP1.
- For other V4.2.x 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
socket specifies the name of the Socket file for the local client to connect to.
Applicability
This variable is available only in 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 values of Global system variables.Modify variables
You cannot modify this variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | /run/sql.sock |
| Scope | Global |
| Modifiable | No. This variable is read-only. |
| Read-only | Yes |
Examples
Query the name of the socket file for the local client to connect to.
obclient> SHOW VARIABLES LIKE 'socket';
The query result is as follows:
+---------------+------------------------------------+
| Variable_name | Value |
+---------------+------------------------------------+
| socket | /home/admin/oceanbase/run/sql.sock |
+---------------+------------------------------------+
1 row in set (0.003 sec)