MySQL Forums
Forum List  »  MySQL Workbench

Trouble specifying directory for secure-file-priv in MYSQL Workbench
Posted by: John Rouse
Date: October 07, 2015 09:01PM

When I run the command mysql> SELECT * FROM customer INTO OUTFILE '/Customer_List.csv'; I get a message:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv opti
on so it cannot execute this statement

I assume that I can change the server using MySQL Workbench , by selecting the Security Tab and selecting the checkbox for secure-file-priv.

However I cannot set a path in the input box that is recognised when I apply the changes. I have tried entering absolute path such as C:\Users

\owner\Downloads but I still get the same message. Can anyone advise. Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Trouble specifying directory for secure-file-priv in MYSQL Workbench
3841
October 07, 2015 09:01PM


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.