Answers for "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement while using outfile"

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

Posted by: Guest on January-06-2021

Code answers related to "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement while using outfile"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement while using outfile"

Code answers related to "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement while using outfile"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement while using outfile"

Code answers related to "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement while using outfile"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us