Amazon RDS无法执行SET GLOBAL命令 [英] Amazon RDS unable to execute SET GLOBAL command

问题描述

我正在将Amazon RDS用于mysql数据库。我想运行一些SET命令，例如：

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?

推荐答案

Amazon不会为您提供RDS实例的SUPER特权（以防止您破坏复制之类的东西）

Amazon does not give you SUPER privileges on an RDS instance (to prevent you from breaking things like replication accidentally).

要配置 group_concat_max_len ，请使用RDS参数组，该参数组允许您配置一组设置

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.

这篇关于Amazon RDS无法执行SET GLOBAL命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！