Amazon RDS unable to execute SET GLOBAL command

问题:

I am using Amazon RDS for mysql db. I want to run some SET commands for eg:

SET GLOBAL group_concat_max_len =18446744073709551615

But when I run this command I get this error

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

When I try to add privileges, it does not allow me to add. Any help or inputs?

回答1:

Amazon does not give you SUPER privileges on an RDS instance (to prevent you from breaking things like replication accidentally).

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

回答2:

With RDS global settings are managed via the ParameterGroup API. You can also edit them from the web console or using the aws command line tools.