issue with secure-file-priv
I am using MySQL version is 5.7.13 on CentOS release 6.7 and facing issue with SELECT ... INTO DUMPFILE as follows
/usr/bin/mysql --login-path=local MyDB -se "CALL _MyProc(@Result);SELECT @Result INTO DUMPFILE '/tmp/mysql/TempFile.txt';"
ERROR 1290 (HY000) at line 1: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
However following command works fine
/usr/bin/mysql --login-path=local MyDB -se "CALL _MyProc(@Result);SELECT @Result INTO DUMPFILE '/tmp/TempFile.txt';"
My.cnf file has entry as secure-file-priv="/"
Seems like MySQL is not able to write into sub-directories on secure-file-priv
Please help me to resolve the issue
Subject
Written By
Posted
issue with secure-file-priv
December 04, 2017 09:32AM
December 04, 2017 10:37AM
December 04, 2017 10:50AM
December 09, 2017 02:54PM
December 12, 2017 07:42AM
December 12, 2017 12:10PM
December 13, 2017 08:24AM
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.