MySQL Forums
Forum List  »  Newbie

Re: How do I disable or work around the mysql-secure-priv option in Windows with MySQL Community Edition?
Posted by: Peter Brawley
Date: January 05, 2022 03:49PM

For non-trivial use of MySQL, you need a my.ini file, https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html.

The Windows default for secure_file_priv is NULL (https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv). That value prohibits all such uploads.

You have two choices in my.ini under the [mysqld] heading:

(i) set secure_file_priv to a folder location, eg c:/in, which you will use for such imports

(ii) set it to "", which is less secure and permits running Load Data from any folder.

In each case, for the change to take effect, restart the server

Options: ReplyQuote




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.