Thursday, November 21, 2013

Setting max_allowed_packet

Hello,

I'm trying so set max_allowed_packet by running the following command from the root user:
SET GLOBAL max_allowed_packet = 999*1024*1024
and I get this error:
Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I need this because my database stores longtext fields which cause import and insert/updates to fail without increasing max_allowed_packet.

Thanks.

--
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/af948fe6-d53a-4daf-ab5d-8964911e5527%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

No comments:

Post a Comment