I am using mysql workbench 8.0.36. I am trying to create a new table and populate it with data from a CSV file. I keep getting error code 1290 –secure-file-priv option issue. I’ve relocated my CSV file to the Uploads folder in MySQL and keep getting this error. I have seen threads here, and elsewhere, with suggestions about changing settings and whatnot, but none of them are resonating. If I put the file in the secure Uploads folder and am referencing it correctly as ‘C:/ProgramData/MySQL/MySQLServer 8.2/Uploads/Myfile.csv’ and keep getting the error. I also tried ‘C:ProgramDataMySQLMySQLServer 8.2UploadsMyfile.csv’ and get the same error. I’ve seen someting about changing my.ini but that is the part I get incredibly lost on. I’ve spent quite a bit of time on this project and I just need this issue solve so I can move forward. Thanks for any help
See above for what I tried and what happened.
Anthony Leroux is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.