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?