🎃

dockerでmysqlイメージ起動時に起きたエラー [ERROR] secure_file_priv

2021/06/26に公開

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

  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/     |
  +---------------------------+

Discussion