CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-ec2amazon-rds
chandresh_cool
chandresh_cool

Reputation: 11830

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?

Upvotes: 29

Views: 21767

Answers (2)

Frederick Cheung
Frederick Cheung

Reputation: 84142

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.

Upvotes: 2

ceejayoz
ceejayoz

Reputation: 180095

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.

enter image description here

Upvotes: 43

Related Questions