To use ‘select … into outfile’ on MySQL the user needs to have the FILE permission as described here. Even with this privilege however, if there server is running with the –secure-file-priv option you’ll see this error: ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option When this option is enabled there’s usually … Continue reading Exporting select result from MySQL and getting the error ‘ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option’