MySQL Forums
Forum List  »  MySQL Workbench

Re: Possible error with the latest Mac version
Posted by: Jon Stephens
Date: September 08, 2017 12:40AM

Hi Nathan,

It's not a "Mac issue" per se, although the default setting for the option indicated may vary between platforms. The error message tells you exactly what the problem is: it's a configuration issue with --secure-file-priv, which controls whether or not the MySQL Server can read and write to files when performing operations such as LOAD DATA, and, if so, which directory the these files must be in.

You can determine the current setting either by examining the options file(s) for the --secure-file-priv option or by checking the value of the secure_file_priv system variable.

This setting cannot be changed while the MySQL Server is running. You must add the option to the server configuration file, or edit it if it's already present, and specify the directory where files to be read or written must be located. Once you've made the change in the configuration file, you must restart the MySQL Server.

Please read the documentation for the option and variable that I've linked above.



Jon Stephens
MySQL Documentation Team @ Oracle
Stockholm, Sweden

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Written By
Re: Possible error with the latest Mac version
September 08, 2017 12: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.