I'm trying to load a CSV file into a database table, but having some issues.
LOAD DATA LOCAL INFILE 'Report_1.csv'
INTO TABLE report_1
Fields terminated by ',' ENCLOSED BY '\"'
LINES terminated by '\n\r'(
company,key_code,dlr_code,rep_code,dlr_name,first_name,last_name)
This gives me the following error: File 'Report_1.csv' not found (Errcode: 2)
So, I tried removing the LOCAL from the SQL above and get this error: Access denied for user 'myusername'@'localhost' (using password: YES)
From what I understand, this means I don't have grant privileges for File, but when I do a "show grants;" I get: GRANT ALL PRIVILEGES ON `mydb`.* TO 'myusername'@'localhost' WITH GRANT OPTION
Isn't this telling me I should already have all grant privileges? Any ideas?