Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
tarasiadis opened this issue Apr 1, 2020 · 4 comments
Open

Comments

@tarasiadis
Copy link

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
Copy link

Same issue here. Anyone able to resolve this?

@nunespe
Copy link

nunespe commented Dec 3, 2020

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

mysqli.allow_local_infile = On

@jamesboy
Copy link

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
Copy link

gpf70sax commented Nov 15, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants