Comments - LOAD DATA INFILE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The SELECT...INTO OUTFILE page mentions that the FILE privilege is required to make that command works. It turns out that FILE is also required to make LOAD DATA INFILE work. Please mention it on this page, although...
...should FILE be required for LOAD? Unlike ...INTO OUTFILE, nothing on the host side is being changed; it's just being used as a data source. The ability to do the load is (presumably) constrained by having INSERT on the target table, since INSERT triggers are activated.
On further consideration, the privilege is required because you might read something you would not otherwise be able to read this way. An unfortunate limitation. Perhaps the privilege could not be required if the LOCAL argument is given, since the user must have access to a local file for the client to read it?