Disable secure-file-priv for MySQL


Trying to execute some special MySQL queries (for example — select into outfile query) you could bump into such an error:

Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

This option is used to restrict on which folders you're allowed to load data from or to. There are some cases when this option is useful, however in most cases it's not, so the simplest solution is to disable it. To do so open your MySQL configuration file. On Linux it is usually located at:


Find [mysqld] section and disable this option by setting an empty string for secure_file_priv parameter:

# ...

Restart MySQL service and you're all set up:

systemctl restart mysqld
Rate this post:
Share this page:

See also how to:

How to update multiple rows within a single query in MySQL
A several useful commands to dump MySQL database, all databases or just a single table
How to install MySQL database server on CentOS 7