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

Several issues can lead to this error message. It can also be related to an incorrect declaration of the database or schema name. For the import IAM permissions, you can refer to this user guide [1].

If using `gcloud` to deploy your Cloud SQL instance [2], then adding `--verbosity=debug` [3] will help debug any issues.

[1]: https://cloud.google.com/sql/docs/mysql/import-export/importing#iam-permissions

[2]: https://cloud.google.com/sdk/gcloud/reference/sql

[3]: https://cloud.google.com/sdk/gcloud/reference#--verbosity

On Monday, December 21, 2020 at 10:15:02 AM UTC+1 @gmail.com wrote:

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/9122af4a-a178-487b-adca-353c9820b95bn%40googlegroups.com.