Menu
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?
412
Troubleshoot database level issuesBe sure that you're using the correct user name and password to access the instance from your DB client. Be sure that the user has the database permissions to connect to the DB instance. Check for any resource throttling in Amazon RDS, such as CPU or memory contention.
When you can't connect to a DB instance, the following are common causes: Inbound rules – The access rules enforced by your local firewall and the IP addresses authorized to access your DB instance might not match. The problem is most likely the inbound rules in your security group.
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.
142
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
