load data infile ERROR 1227 (42501)

OceanBase 技术问题
#1

【产品名称】oceanbase ce 3.1.0

【产品版本】oceanbase ce 3.1.0

【问题描述】

obclient> grant all on *.* to admin;

Query OK, 0 rows affected (0.02 sec)

obclient> load data infile ‘/opt/ob/1.txt’ into table t;

ERROR 1227 (42501): Access denied

#2

 可以尝试参考如下：

MySQL [(none)]> set global secure_file_priv='';

Query OK, 0 rows affected (0.05 sec)


MySQL [(none)]> grant file on *.* to admin;

Query OK, 0 rows affected (0.03 sec)


1 个赞
#3

谢谢，可以了