Amazon RDS unable to execute SET GLOBAL command

mysql amazon-web-services amazon-ec2 amazon-rds
chandresh_cool picture chandresh_cool · Jun 30, 2015 · Viewed 13.9k times · Source

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?

Answer

ceejayoz picture ceejayoz · Jun 30, 2015

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

Related questions

MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.…

Read More
How to export database from Amazon RDS MySQL instance to local instance?

AWS documentation has this page that talks about importing and exporting data from MySQL server, but it's mostly about import. The only thing I see in their documentation is a way to export 5.6 data using replication, which is documented here. …

Read More
Can't connect to RDS instance from EC2 instance

From EC2 instance i-78a8df00, I'm trying to connect to RDS instance mysql.************.us-east-1.rds.amazonaws.com. They are both in the U.S. East region. I added the security group of EC2 instance (sg-********) to the RDS security …

Read More