Mysql permission errors with 'load data'

Solution 1:

Here's a thread on the MySQL forums that discusses exactly this.

Here's the answer, posted by Ken Tassell

Problem resolved using the command below:

grant file on *.* to kentest@localhost identified by 'kentest1';

Solution 2:

You might have MySQL privileges on the destination table, but you also need the FILE privilege to execute LOAD DATA, and of course the MySQL Server process needs operating-system privileges to the data file too.

Mysql permission errors with 'load data'

Solution 1:

Solution 2:

Related

Recent Posts