Answers for "How to solve 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'"

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 "How to solve 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "How to solve 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'"

Code answers related to "How to solve 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "How to solve 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'"

Code answers related to "How to solve 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us