secure_file_priv specifies the path in which file import and export can be performed. This variable can be specified only by the database administrator (DBA).
Notice
For security reasons, an SQL statement that modifies this global variable can only be executed by a client connected by using a local Unix socket.
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | "NULL" |
| Value range |
|
| Applicable scope | Global |
| Plan generation affected | Yes |
| Nullable | Yes |
The following example shows how to connect to OceanBase Database by using a local Unix socket:
obclient -S /home/admin/oceanbase/run/sql.sock -u******@obtenant
where
-Sspecifies the path to the Unix socket file for the local OBServer node. The file is namedsql.sockand is in therun/directory in the local OBServer installation directory. The default value is/home/admin/oceanbase/run/sql.sock.-uspecifies the tenant account name in the Username@Tenant name format.
You can connect to only a local OBServer node by using a Unix socket connection. Make sure that the resources of the tenant are distributed across local OBServer nodes. Otherwise, you cannot connect to the tenant by using the local OBServer node.