obclient(root@test_tenant)[oceanbase]> grant file on . to root;
Query OK, 0 rows affected (0.488 sec)
obclient(root@test_tenant)[oceanbase]> show variables like ‘secure%’;
±-----------------±------+
| Variable_name | Value |
±-----------------±------+
| secure_auth | ON |
| secure_file_priv | |
±-----------------±------+
2 rows in set (0.006 sec)
obclient(root@test_tenant)[oceanbase]> show variables like ‘secure%’;
±-----------------±------+
| Variable_name | Value |
±-----------------±------+
| secure_auth | ON |
| secure_file_priv | |
±-----------------±------+
2 rows in set (0.015 sec)
obclient(root@test_tenant)[oceanbase]> set global secure_file_priv = ‘/mnt/nfs_share’;
Query OK, 0 rows affected (0.029 sec)
obclient(root@test_tenant)[oceanbase]> show variables like ‘secure%’;
±-----------------±------+
| Variable_name | Value |
±-----------------±------+
| secure_auth | ON |
| secure_file_priv | |
±-----------------±------+
2 rows in set (0.023 sec)
obclient(root@test_tenant)[oceanbase]> select version();
±-----------------------------+
| version() |
±-----------------------------+
| 5.7.25-OceanBase_CE-v4.4.1.0 |
±-----------------------------+
1 row in set (0.018 sec)
