Forums

SET GLOBAL group_concat_max_len = 1000000;

When trying to set the group_concat_max_len variable I get the following error: ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

How can I solve this?

You can change only variable in the session scope -- so try SET group_concat_max_len = 1000000;