I am trying to import data from a CSV file that is stored in a Bucket. The CSV file uses the "|" delimiter. I would like to import these data to a MySQL database on Cloud SQL.
However, I found out that the root user by default does not have the "File" privilege, which means I cannot perform this import via MySQL Workbench.
I tried to use the command LOAD DATA INFILE, but I got the following error:
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
I also tried to use the tool gcloud sql import csv, but I got another error:
ERROR: (gcloud.sql.import.csv) HTTPError 403: The service account does not have the required permissions for the bucket.
I do not know how to solve this problem. Could anyone help me with this? Any suggestion or guidance would be very welcome.
Thank you!
You could try reformatting your CSV file to be delimited by something else, e.g.
,?