Sunday, December 20, 2020

[google-cloud-sql-discuss] Cloud SQL import issues

When I try to import the data from cloud storage, I get the following message
Error 1142: INSERT command denied to user 'cloudsqlimport'@'127.0.0.1' for table 't1'  

When I try to grant insert privileges to cloudsqlimport from mysqlworkbench or 
cloud shell > mysql>
UPDATE `mysql`.`user` SET `Grant_priv` = 'Y' WHERE `User` = 'root';
ERROR 1142 (42000): UPDATE command denied to user 'root'@'104.xxx..xx.xx' for table 'user'  

Is there any way to grant these privileges to cloudsqlimport?

Documentation says 
  1. You can optionally specify a user to use for the import.
Where/how I can specify the schema table owner as a user to use for the import?

Any other guidance here?

Thanks

--
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/ad1a6d02-c6af-42e2-bc05-605a6274c0f6n%40googlegroups.com.

No comments:

Post a Comment