MySQL ERROR 1290 (HY000) –secure-file-priv option - Stack Overflow

1
2
3
4
5
6
7
8
9
  mysql> load data infile 'account.csv' into table authapi.account   fields     terminated by ','     enclosed by '"';  
  ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
  
  mysql> SELECT @@GLOBAL.secure_file_priv;
  +---------------------------+
  | @@GLOBAL.secure_file_priv |
  +---------------------------+
  | /var/lib/mysql-files/     |
  +---------------------------+