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
- 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