When I tried to do
set GLOBAL group_concat_max_len = 4294967295
in cpanel, I get the error
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
I've got when run command "set GLOBAL group_concat_max_len = 4294967295" in cpanel
Viewed 14
1 Answers
The command to give the permission (on your database) should be something like this: GRANT SUPER ON . TO user@'localhost' IDENTIFIED BY 'passwordName';
But like @RiggsFolly and @Akina said, check the need in doing this.
Related