The problem of Amazon RDS being unable to execute the SET GLOBAL command still exists

Question

I am using Amazon RDS for mysql database. I want to run some SET commands like:

SET GLOBAL group_concat_max_len =18446744073709551615

But when I run this command, I get the following error:

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

When I try to add permissions, it doesn't allow me to add them. Any help or suggestions?

Answer 1

Using RDS, global settings are managed through the ParameterGroup API. You can also edit via the web console or using the aws command line tools.

Answer 2

Amazon will not give you SUPER permissions on the RDS instance (to prevent you from accidentally breaking things like replication).

To configure group_concat_max_len, use the RDS parameter group, which allows you to configure a set of settings and apply them to an instance.