Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
MySQL can't use "LOAD DATA INFILE", secure-file-priv option is preventing execution.
I am trying to run a simple code to mysql db but it’s preventing me to do so.
The code is tested on my xampp environment and it works.
the code that i am trying to use is this:
LOAD DATA INFILE '/var/www/laravelapp/storage/app/file.txt' INTO TABLE test FIELDS TERMINATED BY '|';
the error that I get is:
ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
I have searched for a fix and a lot of people recommend to add
secure-file-priv = "" to my.cnf file under the mysqld config group
But I know that i am missing smth because I have added the configuration line at my.cnf file
restarted mysql server with the commands:
service mysql restart or service mysql stop service mysql start or /etc/init.d/mysql restart
This is part of my.cnf file:
# This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # secure-file-priv = "" user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning
Also tried to add it at the end of the file, in other parts, or to change the syntax:
secure-file-priv = " " secure_file_priv = "" secure_file_priv = " "
but still without success.
Pls any idea how can I run:
LOAD DATA INFILE
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×