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?