Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
Experts Most Trusted Topic
mysql permission errors with load data
mysql permission errors with load data ¬†using -'mysql,load-data-infile,mysql-error-1045'
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'@'%
Oct 11, 2015
to add a comment.
Related Hot Questions
Walkin Jobs Opening
Government Jobs Opening