Virgin install:LOAD DATA LOCAL INFILE is forbidden

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Virgin install:LOAD DATA LOCAL INFILE is forbidden

Postby gunfacts » 04. February 2024 16:03

Installed XAMPP for the first time in Win10, fully patched.

Everything works OK aside from using the "LOAD DATA LOCAL INFILE" SQL command. It generates the error "LOAD DATA LOCAL INFILE is forbidden, check related settings ..."

So I edited all the local settings that other tech sites discussed, particularly "mysqli.allow_local_infile = On", etc. Restarted Apache and MySQL. Error persists.

Wondering if there is a common XAMPP specific situation that is preventing me from loading data (which I need ... MySQLWorkbench would have taken about two weeks to load the data file I'm working with).
gunfacts
 
Posts: 2
Joined: 04. February 2024 15:57
XAMPP version: 8.0.30
Operating System: Windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 123 guests