以下是我的会话，我的数据位于mysql所有者/组的目录中
    mysql -u root -p     输入密码：     欢迎使用MySQL监视器。命令以;结尾;或\ g。     您的MySQL连接ID为8     服务器版本：8.0.18 MySQL Community Server-GPL

Copyright (c) 2000,2019,Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set global local_infile = 1;
Query OK,0 rows affected (0.00 sec)

mysql> use SSC;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> load data local infile '/storage/temp/myest1.csv' into table SSC fields terminated by ',' lines terminated by '\n' ignore 1 lines;
ERROR 1148 (42000): The used command is not allowed with this MySQL version
mysql> show variables like "local_infile";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+
1 row in set (0.00 sec)

mysql> load data local infile '/storage/temp/myest1.csv' into table SSC;
ERROR 1148 (42000): The used command is not allowed with this MySQL version
mysql> load data local infile 'myest1.csv' into table SSC;
ERROR 1148 (42000): The used command is not allowed with this MySQL version
mysql> SELECT @@global.secure_file_priv;
+---------------------------+
| @@global.secure_file_priv |
+---------------------------+
| /storage/temp/            |
+---------------------------+
1 row in set (0.00 sec)