Tuesday, August 4, 2020

[google-cloud-sql-discuss] Access denied for user 'root'@'%' (using password: YES) with mysql hosted in GCP

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