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

mysql amazon-web-services amazon-rds-aurora
sashoalm picture sashoalm · Oct 10, 2017 · Viewed 18.5k times · Source

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?

Answer

sashoalm picture sashoalm · Oct 10, 2017

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.

Related questions

AWS Aurora MySQL serverless: how to connect from MySQL Workbench

I was trying to use AWS Aurora Serverless for MySQL in my project, but I am impossible to connect to it, though I have the endpoint, username, password. What I have done: From AWS console managment, I select RDS > …

Read More
Amazon RDS Aurora vs RDS MySQL vs MySQL on EC2?

I've been looking around for best practices when setting up your database on the cloud but it still isn't clear to me which of the following solutions should we be going for? Amazon RDS Aurora Amazon RDS MySQL MySQL on …

Read More
AWS RDS Writer Endpoint vs Reader Endpoint

I created an Amazon Aurora instance in my VPC. When the instance was created, it came with 2 endpoints, a writer and a reader endpoint. The instance is using a security policy with an ingress rule (Type: All Traffic, Protocol: All, …

Read More