Disable secure-file-priv for MySQL
1468
5
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:
/etc/my.cnf
Find [mysqld]
section and disable this option by setting an empty string for secure_file_priv
parameter:
[mysqld]
# ...
secure_file_priv=""
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