AWS Aurora:MySQL 服务器使用 --read-only 选项运行,因此无法执行此语句

我在 AWS 中的 Aurora 数据库实例上执行 GRANT 语句时收到此错误:

I am getting this error when executing a GRANT statement on my Aurora DB instance in AWS:

MySQL 服务器使用 --read-only 选项运行,因此无法执行此语句

The MySQL server is running with the --read-only option so it cannot execute this statement

我的用户不是只读的,为什么会发生这种情况?

My user is not read-only though, so why is this happening?

推荐答案

结果证明这是一个愚蠢的错误,但还是发布了,以防其他人遇到问题:

It turned out to be a silly mistake, but posting it anyway in case anyone else has the problem:

我错误地访问了副本实例 - 我复制了副本的端点,它显然是只读的.因此,如果您遇到此问题,请验证您是连接到主实例还是最好的数据库集群端点.

I was accessing the replica instance by mistake - I had copied the endpoint for the replica, and it is read-only apparently. So if you have this problem, verify that you are connecting to the Primary Instance or best of all the DB Cluster endpoint.

根据@Justin 的回答,我们绝对应该使用数据库集群:

According to @Justin's answer we definitely should use DB Cluster:

您需要连接到集群,而不是实例.这是因为实例似乎要轮流成为读者和作者.

You need to connect to the cluster, rather than an instance. This is because instances seem to take a turn to be the readers and writers.

相关文章