I have created a GCP SQL Instance and trying to load a CSV file into mysql table using below query.
LOAD DATA INFILE 'D:/test.csv'
INTO TABLE discounts
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(title,@expired_date,amount)
SET expired_date = STR_TO_DATE(@expired_date, '%m/%d/%Y');
But getting below error.
Error Code: 1045. Access denied for user 'root'@'%' (using password: YES)
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e2ff5688-701e-449a-87fb-40eb4acdc12co%40googlegroups.com.
No comments:
Post a Comment