MySQL Forums
Forum List  »  General

Re: issue with secure-file-priv
Posted by: Walter Griffith
Date: January 20, 2018 10:40AM

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??

Options: ReplyQuote


Subject
Written By
Posted
December 04, 2017 09:32AM
December 04, 2017 10:50AM
December 09, 2017 02:54PM
December 12, 2017 07:42AM
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.