I'm trying to load data infile from mysql workbench to cloud sql but i'm getting these errors,
Error Code: 1045. Access denied for user 'root'@'%' (using password: YES)
This is the query i'm using
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/testupload.csv' replace INTO TABLE test_users FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
I've tried to upload csv file from bucket list from google storage, successfully uploaded but here objective is when i upload a csv file while duplicate key encountered need to replace the existing records.
Please help me out!!!
