Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

# Check the default location of secure_file_priv
SHOW VARIABLES LIKE "secure_file_priv";

# Save the file in that location
Select ... From ... INTO OUTFILE ...
 
PREVIOUS NEXT
Tagged: #ERROR #The #MySQL #server #running #option #execute #statement
ADD COMMENT
Topic
Name
2+1 =