search

Home  >  Q&A  >  body text

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

<p>I am using Amazon RDS for mysql database. I want to run some SET commands like: </p> <pre class="brush:php;toolbar:false;">SET GLOBAL group_concat_max_len =18446744073709551615</pre> <p>But when I run this command, I get the following error: </p> <pre class="brush:php;toolbar:false;">ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation</pre> <p>When I try to add permissions, it doesn't allow me to add them. Any help or suggestions? </p>
P粉265724930P粉265724930467 days ago664

reply all(2)I'll reply

  • P粉378264633

    P粉3782646332023-08-25 10:25:13

    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.

    reply
    0
  • P粉115840076

    P粉1158400762023-08-25 00:21:51

    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.

    reply
    0
  • Cancelreply