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.
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.