Setting group_concat_max_len variable

Hi,

I’m trying to modify the value of the variable group_concat_max_len using the following statement:

SET GLOBAL group_concat_max_len = 104857600

When I run that query I get the following error:

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

I’m using Helios and running the command via the admin user. I’m able to set the variable for the SESSION, but I cannot set it globally. Is there any way to do that?

Thanks!

Yeah, you can’t currently set this variable globally yourself in Helios. If your a paying customer reach out to support and they can adjust it for you.

We are also looking at increasing the default value of group_concat_max_len in a future release - the current default is too small (its very common for folks to adjust it higher).

-Adam

1 Like