Virgin install:LOAD DATA LOCAL INFILE is forbidden
Posted: 04. February 2024 16:03Installed 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).
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).