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 ...
1 answer • 1 day ago • By Anjanesh LekshminarayananDigitalOcean Managed MySQL DatabaseMySQL
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...
No answers yet • 8 days ago • By Jérémie L.DigitalOcean Managed MySQL DatabaseMySQLSQL
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...
1 answer • 10 days ago • By Vaibhav ChauhanDigitalOcean Managed MySQL DatabaseMySQL
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...
1 answer • 10 days ago • By gabbaDigitalOcean Managed MySQL DatabaseWordPress
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...
1 answer • 17 days ago • By Diesel Utama IndonesiaDigitalOcean Managed MySQL DatabaseMySQL
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...
1 answer • 19 days ago • By Anjanesh LekshminarayananDigitalOcean Managed MySQL Database
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...
2 answers • 21 days ago • By Mohit PandeyDatabasesDigitalOcean Managed MySQL DatabaseMySQLWordPress
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.
1 answer • 23 days ago • By Heriberto SosaDigitalOcean Managed MySQL Database
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...
1 answer • 1 month ago • By Mohit PandeyDigitalOcean DropletsDigitalOcean Managed MySQL DatabaseMySQL
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...
1 answer • 1 month ago • By Mohit PandeyDatabasesDigitalOcean DropletsDigitalOcean Managed MySQL Database
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...
Accepted Answer: Hi @jimwigginton , the command you’ve used: sed 's/SET @@SESSION.SQL_LOG_BIN.*//' -i backup.sql sed 's/SET @@GLOBAL.GTID_PURGED.*//' -i backup.sql I’m glad it has helped you. Having said that, yes the doadmin user on ...
2 answers • 1 month ago • By Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQL
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...
Accepted Answer: DigitalOcean support gave me this alternative query to run to find the problem tables: SELECT tab.table_schema AS database_name, tab.table_name AS table_name, tab.table_rows AS table_rows FROM information_schema.table...
2 answers • 1 month ago • By Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQL
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...
No answers yet • 2 months ago • By Chris SeegersDigitalOcean Managed MySQL DatabaseDNSUbuntu 20.04
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...
No answers yet • 2 months ago • By Max HeroldDigitalOcean Managed MySQL DatabaseDigitalOcean Managed PostgreSQL Database
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...
1 answer • 2 months ago • By Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQLPHP
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...
1 answer • 2 months ago • By DwikavindraDigitalOcean Managed MySQL DatabaseMySQL
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...
1 answer • 2 months ago • By MassiveTealAnglerDigitalOcean Managed MySQL Database
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...
1 answer • 3 months ago • By scottfriebelDatabasesDigitalOcean Managed MySQL DatabaseMySQL
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.
1 answer • 3 months ago • By Kingsley EkwuemeBuilding on DigitalOceanDigitalOcean Managed MySQL DatabaseSecurity