Question

How to drop managed database

Posted August 20, 2021 91 views
DigitalOcean Managed MySQL Database

When I try to drop managed database:

mysql -u userName -pXXXXX -h dbsxx-do-user-977-0.a.db.ondigitalocean.com -P 25060 -e “drop database dbName”

I run Into This error:
RROR 1290 (HY000) at line 1: The MySQL server is running with the –read-only option so it cannot execute this statement

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hello,

You need to make sure that you are connecting to the primary server and not one of the read-only replicas.

The read-only replicas can only be used for read operations.

Regards,
Bobby