0

I'm doing load data infile with MySQL on OSX El Capitan, however, the following error happened:

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I try to fix it my modify my.cnf or use any .cng in /usr/local/mysql/support-files to create a my.cnf file. But there isn't any file with .cnf extension. Here is file list in /usr/local/mysql/support-files:

magic           mysql.server

mysql-log-rotate mysqld_multi.server Could any body provide me the path to .cnf in OSX?

Cœur
  • 34,719
  • 24
  • 185
  • 251
SKSKSKSK
  • 487
  • 1
  • 4
  • 11
  • Or any other way that could help me to fix this problem – SKSKSKSK Apr 16 '17 at 07:37
  • There are several answers on Stackoverflow regarding the location of the my.cnf file. For example, see http://stackoverflow.com/questions/10757169/mysql-my-cnf-location-on-os-x – not2savvy Apr 26 '17 at 16:42

1 Answers1

0

Instead of solving the problem, I downgraded the mysql to 5.6, and then added and modified the parameter in my.cnf following lots of answer to the similar question about mysql 5.6.

SKSKSKSK
  • 487
  • 1
  • 4
  • 11