【产品名称】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
【产品名称】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
可以尝试参考如下:
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)
谢谢,可以了