show secure-file-priv in mysql by query
SHOW VARIABLES LIKE "secure_file_priv";
show secure-file-priv in mysql by query
SHOW VARIABLES LIKE "secure_file_priv";
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 ...
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us