PHP Warning: mysqli_query(): LOAD DATA LOCAL INFILE forbidden in

[tarasiadis]

It works great on my setup this script but last month I get below error

PHP Warning: mysqli_query(): LOAD DATA LOCAL INFILE forbidden in

Is there any update on it?

[carlcarlsoniv]

Same issue here. Anyone able to resolve this?

[nunespe]

I had this problem today and solved it by setting the following in php.ini

mysqli.allow_local_infile = On

[jamesboy]

Basically you need:

PDO::MYSQL_ATTR_LOCAL_INFILE => true

Set at instantiation.

https://stackoverflow.com/questions/7638090/load-data-local-infile-forbidden-in-php

[gpf70sax]

Hi, I get the same error using Adminer to execute a sql LOAD DATA LOCAL INFILE, I try to set the variable mysqli.allow_local_infile = on in my /etc/php/7.4/apache2/php.ini directory and stop/start the apache2 service, but it doesn't work Any suggest? Thank you, Gianpiero