AWS Aurora: The MySQL server is running with the --read-only option so it cannot execute this statement
Solution 1
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.
Edit: 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.
Solution 2
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.
sashoalm
Updated on November 19, 2020Comments
-
sashoalm over 3 years
I am getting this error when executing a
GRANT
statement on my Aurora DB instance in AWS: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?