MySQL Forums
Forum List  »  MySQL Workbench

Re: LOAD DATA security error
Posted by: Randy Park
Date: May 16, 2019 09:40AM

I used Workbench to change the option, because I don't know where the startup options file is located, what format it is in (text, binary, etc), or what allowable values each option has. From within Workbench, I changed only the secure-file-priv option because that is what the error pointed to. The choices available are only: turn it on, and turn it off.

I found a file called mysql.ini and it had only 1 text line in it: [mysqld]
I left it alone.

I find the fact that the workbench reports that the server refuses to shut down, somewhat troubling. This forces me to shut down the OS when I need to change startup options. But this is really a separate problem.

Options: ReplyQuote

Written By
May 14, 2019 09:42AM
May 14, 2019 09:54AM
Re: LOAD DATA security error
May 16, 2019 09:40AM
May 16, 2019 10:01AM

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.