ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option

CSV文件导入mysql报错

mysql> load data infile '/u01/my3306/data/test/test.csv'
    -> into table ld_csv1
    -> fields terminated by ',' optionally enclosed by '"' escaped by '"'  
    -> lines terminated by '\r\n';  
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

1. 查看mysql secure_file_prive的值

mysql> show variables like "secure_file_priv";
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| secure_file_priv | NULL  | # NULL：限制mysqld不允许导出
+------------------+-------+
1 row in set (0.00 sec)

secure_file_priv=/tmp/ ：限制mysqld的导入导出只能发生在/tmp/目录下

secure_file_priv=' '