cancel
Showing results for 
Search instead for 
Did you mean: 

LOAD DATA INFILE problem

N/A

LOAD DATA INFILE problem

Can anyone point the way as to why we can't use the following:

LOAD DATA INFILE 'INFILE3.SQL' INTO TABLE tran_headers_build FIELDS TERMINATED BY ',' ENCLOSED BY '\'' IGNORE 2 LINES;

It gives:

ERROR 1045 at line 10: Access denied for user: 'tectonics@%' (Using password: YES)

This works fine on our internal MySQL server.
I'm assuming it's because we haven't been granted the FILE privilege. Can anyone confirm this, or let me know how to find out whether we do or don't have this privilege, and if we don't, can Force9 Support please grant this.

Thanks
Alex