I am interested in Managed MySQL Databases . But spending $15 / month for each website is way too expensive. I was wondering if using the Basic 1GB @ $15 / mo is efficient for all my websites (on and off DO) using it ...

Hi, I have several managed MySQL databases and I have set up several event scheduler jobs for maintenance. None of the scheduled events run correctly and I see errors in the “Logs & Queries” DigitalOcean dashboard, su...

I want to do some file operations on my managed mysql. I tried adding privileges using GRANT ALL ON testdb.* TO 'sammy'@'%' WITH GRANT OPTION;but this does not do the trick.I also tried grant file on testdb.* to 'samm...

Trying to use wp-cli with our managed database from our droplet, wordpress works and connects fine on the front end and admin, but connections via wp-cli just give me a" Error establishing a database connection." Obvi...

I have database of the size 4gb that i would like to import into DO Mysql managed database. I tried using mysqlimport with multiple threads but having trouble getting the process to start mysqlimport: Error: 1227 Acce...

I have a couple of databases (say 5 for calculation purpose) and am thinking of using managed MySQL database. Thing is, I don’t want to spend $15 x 5 = $75 per month. The pricing - https://www.digitalocean.com/pricing...

I can access my website but can’t log into my wordpress website. When I do that I get Database error. I tried doing repairing database but it still showed my database error. I don’t know what happened but I haven’t ch...

I’ve searched the docs and forums regarding how to set timezone in my database cluster managed by DO, but I can’t change it to UTC -04:00. Any help would be greatly appreciated.

Is it possible to view the slow queries log on a managed database? I don’t see it under the “Logs & Queries” tab, as suggested.

So, my site got messed up due to DDoS attack due to which I had to uninstall and install MYSQL again. I found that it isn’t wordpress database and the backup which I have is corrupted one and another backup which I ha...

I was facing some issue with mysql so I had uninstalled it completely and then reinstalled it again. So, when I went to my website now it was giving me “Error Establishing Database Connection” Just to confirm everythi...

I made a dump of a MySQL DB with mysqldump and am now trying to restore it to my DigitalOcean managed DB using the doadmin user and I get this error: ERROR 1227 (42000) at line 18: Access denied; you need (at least on...

I’ve been getting these emails daily from DigitalOcean: Our systems have indicated that your MySQL cluster, [placeholder], has tables without primary keys. We have identified that MySQL tables without primary keys can...

I have a standard droplet (Ubuntu 20.04) and a managed MySQL 8 database. Both are in the same VPC. On the droplet an application is connecting to the database via the hostname suitable to be used within the VPC:privat...

When in Databases -> some db cluster -> Insights -> Manage Alert Policies, I can’t get the following two things to work: (1) selecting db clusters via tags: any tags I select are gone after I save (getting a successfu...

When I run PHP’s mysqli_connect() to connect to a newly created MySQL 8 database cluster I get the following error: PHP Warning: mysqli_connect(): The server requested authentication method unknown to the client [cach...

Hi I’m currently working on a group project, where my friend has to access the database on the mysql server hosted in Digital Ocean. We have a problem that seems to only occur for my friend’s mysql workbench on Window...

Your database access does not have the privileges to create tables in the “presta_shop” database. Check with your hosting provider:Storage engine MyISAM is disabled (Table creation is disallowed).You must have read pe...

I configured the existing mysql db on the current droplet with a user with full permissions and allowed external connections to the db. Then went through the “set up migration” steps on the Managed DB page (entered ho...

Good day.Please I want to find out if there is any policy on account lockout. My team wants to know if this document is available as we have industry regulators asking about this.