[google-cloud-sql-discuss] Google Cloud SQL 2nd Gen - Error Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Dear All,


we are testing the Google Cloud features and services in order to migrate our infrastructure on Google.


We are testing the SQL service, but during the import we have some problems with this error:
- Access denied; you need (at least one of) the SUPER privilege(s) for this operation


Searching for a possible solution we tried to set the flag:
log_bin_trust_function_creators => On

We tried to disable the binary logging and remove replicas, but nothing, we have the same problem:

ERROR 1227 (42000) at line 71: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

The lines are similar to:

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `deleteVideoInSpace` BEFORE DELETE ON `tbl_ugvideos` FOR EACH ROW UPDATE tbl_spaces

or:

/*!50001 CREATE ALGORITHM=UNDEFINED */

any ideas? 

thank you in advance

--
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/cd4d8bdb-3463-4ec5-9c95-ec7466bfe10a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.