问题描述
我在 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.
这篇关于AWS Aurora:MySQL 服务器使用 --read-only 选项运行，因此无法执行此语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！