I am running into a permission error when trying to load data from a flat file database dump into a new table. I know that the schema of the file and my table is the same and I tried tweaking the permissions. What else should I try?
mysql> load data infile 'myfile.txt' into table mytable fields terminated by ',' enclosed by '"';
ERROR 1045 (28000): Access denied for user 'user'@'%'
grant all on mytable.* to 'user'@'%
Here's a thread on the MySQL forums that discusses exactly this.
Here's the answer, posted by Ken Tassell
You might have MySQL privileges on the destination table, but you also need the
FILE
privilege to executeLOAD DATA
, and of course the MySQL Server process needs operating-system privileges to the data file too.