The problem of Amazon RDS being unable to execute the SET GLOBAL command still exists
P粉265724930
2023-08-24 14:42:31
<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>
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
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.
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.