[google-cloud-sql-discuss] Re: Errors when importing gen 1 v5.6 into gen 2 v5.6

Without setting log-bin-trust-function-creators this is the error I get:

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

I'm pretty sure this is due to a DEFINER clause on a CREATE TRIGGER statement.

However, this *is* something that needs to be able to happen on an import. Changing the dump file is not a solution as the permissions do need to be set.

How can I work around this? Is this a bug that will be fixed?

--
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/da626c00-6e9d-4cf7-9f7a-78041923b2cc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.