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.

cheers

jon.

Jon Stephens
MySQL Documentation Team @ Oracle
Stockholm, Sweden

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Possible error with the latest Mac version
121
September 08, 2017 12:40AM


Sorry, only registered users may post in this forum.

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.