Wsrtjtyk

I had the same issue. I finally solved using the LOCAL option in the command

LOAD DATA LOCAL INFILE "text.txt" INTO TABLE mytable;

You can find more info here http://dev.mysql.com/doc/refman/5.7/en/load-data.html

If LOCAL is specified, the file is read by the client program on the
client host and sent to the server. The file can be given as a full
path name to specify its exact location. If given as a relative path
name, the name is interpreted relative to the directory in which the
client program was started.

On Ubuntu 14 and Mysql 5.5.53 this setting seems to be enabled by default. To disable it you need to add secure-file-priv = "" to your my.cnf file under the mysqld config group. eg:-

[mysqld]

secure-file-priv = ""

I'm working on MySQL5.7.11 on Debian, the command that worked for me to see the directory is:

mysql> SELECT @@global.secure_file_priv;

If the file is local to your machine use the LOCAL in your command

LOAD DATA LOCAL INFILE "text.txt" INTO table mytable;

Here is what worked for me in Windows 7 to disable secure-file-priv (Option #2 from vhu's answer):

1. Stop the MySQL server service by going into services.msc.


2. Go to C:ProgramDataMySQLMySQL Server 5.6 (ProgramData was a hidden folder in my case).


3. Open the my.ini file in Notepad.


4. Search for 'secure-file-priv'.


5. Comment the line out by adding '#' at the start of the line. For MySQL Server 5.7.16 and above, commenting won't work. You have to set it to an empty string like this one - secure-file-priv=""
   


6. Save the file.


7. Start the MySQL server service by going into services.msc.

I had the same problem with 'secure-file-priv'. Commenting in the .ini file didn't work and neither did moving file in directory specified by 'secure-file-priv'.

Finally, as dbc suggested, making 'secure-file-priv' equal to an empty string worked. So if anyone is stuck after trying answers above, hopefully doing this will help.

I had all sorts of problems with this. I was changing my.cnf and all sorts of crazy things that other versions of this problem tried to show.

What worked for me:

The error I was getting

The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I was able to fix it by opening /usr/local/mysql/support-files/mysql.server and changing the following line:

$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" -- $other_args >/dev/null &

  wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

to

$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" --secure-file-priv="" $other_args >/dev/null &

  wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

The thing that worked for me:

1. Put your file inside of the folder specified in secure-file-priv.

To find that type:

mysql> show variables like "secure_file_priv";

2. Check if you have local_infile = 1.

Do that typing:

mysql> show variables like "local_infile";

If you get:

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| local_infile  | OFF   |

+---------------+-------+

Then set it to one typing:

mysql> set global local_infile = 1;

3. Specify the full path for your file. In my case:

mysql> load data infile "C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/file.txt" into table test;

I had this problem on windows 10. "--secure-file-priv in MySQL" To solve this I did the following.

1. In windows search (bottom left) I typed "powershell".


2. Right clicked on powershell and ran as admin.


3. Navigated to the server bin file. (C:Program FilesMySQLMySQL Server 5.6bin);


4. Typed ./mysqld


5. Hit "enter"

The server started up as expected.

MySQL use this system variable to control where you can import you files

mysql> SHOW VARIABLES LIKE "secure_file_priv";

+------------------+-------+

| Variable_name    | Value |

+------------------+-------+

| secure_file_priv | NULL  |

+------------------+-------+

So problem is how to change system variables such as secure_file_priv.

1. shutdown mysqld
   


2. sudo mysqld_safe --secure_file_priv=""

now you may see like this:

mysql> SHOW VARIABLES LIKE "secure_file_priv";

+------------------+-------+

| Variable_name    | Value |

+------------------+-------+

| secure_file_priv |       |

+------------------+-------+

Detailed example on how to check secure_file_priv, grant user and select into outfile yippeecode.com