Re: issue with secure-file-priv
Please pardon me for popping in, but I seem to be having a very similar problem. I'm running on a MacBook Pro with macOS 10.13.2. I'm using a SELECT ... INTO.. statement like Mr. Ali and I get the same error. I ran mysqladmin to check the value of secure-file-priv and it is indeed NULL (allowing no file writes). I'm trying to change it by editing my ~/.my.cnf file (the only option file that exists on my system) by appending these lines:
[mysqld]
secure-file-priv=
but this doesn't change secure-file-priv (I've also tried secure..='', secure..="", and in desperation: secure..=empty. Any suggestions??
Subject
Written By
Posted
December 04, 2017 09:32AM
December 04, 2017 10:37AM
December 04, 2017 10:50AM
December 09, 2017 02:54PM
December 12, 2017 07:42AM
December 12, 2017 12:10PM
December 13, 2017 08:24AM
Re: issue with secure-file-priv
January 20, 2018 10:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.