Thursday, October 13, 2016

[google-cloud-sql-discuss] I can't create functions

Hi, i have the follow problem:
I created an instance, I connect to it from toad with the root user and launched a script to create all the objects in my database, tables, functions, procedures, etc. When creating the first function throws me the following error:

MySQL Database Error: You Do not have the SUPER privilege and binary logging is enabled (you * might * want to use the less safe Variable log_bin_trust_function_creators)

The binary logging is enabled and I can not disable via the console.
The root user also has the privilege "super".

What I can do?

thanks for your comments.

--
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/bd15b21f-fb8b-4769-a243-9aa0a6767d0a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment