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;
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.