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

Hi Carlos,

I tried your workaround but i haved this error 

"HTTPError 403: The client is not authorized to make this request"

you can help me

Il giorno venerdì 14 ottobre 2016 17:26:57 UTC+2, Carlos (Cloud Platform Support) ha scritto:

Hi Beto,

It is important to note that Google Cloud SQL does not support SUPER privileges. The behavior is fully documented in our Cloud SQL FAQ. There are also some other unsupported features like ¨User defined functions¨. Nevertheless Stored Procedures are supported.

The log_bin_trust_function_creators MySQL flag controls whether stored function creators can be trusted or not to create stored functions that will cause unsafe events to be written to the binary log. By default in Cloud SQL its value is OFF meaning users are not permitted to create or alter stored functions, unless they have the 'SUPER privilege' which is not supported in Cloud SQL. 

As a workaround, you can set the log_bin_trust_function_creators to ON by running this gcloud sql command:

gcloud sql instances patch [INSTANCE_NAME] --database-flags log_bin_trust_function_creators=ON

Let me know if this helps. 

--
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/ca7f62e5-2f25-4e78-9f91-bb7504e95820%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.