Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch 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'@'%


asked Oct 11, 2015 by badhwar.rohit
0 votes

Related Hot Questions

Government Jobs Opening