DigitalOcean Managed MySQL Database

Subscribe to DigitalOcean Managed MySQL Database
Get notified when new articles on DigitalOcean Managed MySQL Database are published.
  • 20 Results
    All time
    • Question

      Single Managed MySQL Database for all my Websites including sites not on DO

      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 answer1 day agoBy Anjanesh LekshminarayananDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Managed MySQL database - Event Scheduler errors

      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 yet8 days agoBy Jérémie L.DigitalOcean Managed MySQL DatabaseMySQLSQL
    • Question

      How to give file permission to user in Managed Mysql

      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 answer10 days agoBy Vaibhav ChauhanDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      WP-CLI - Managed database connection issues

      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 answer10 days agoBy gabbaDigitalOcean Managed MySQL DatabaseWordPress
    • Question

      How to import big MYSQL table into DO Managed database

      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 answer17 days agoBy Diesel Utama IndonesiaDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Managed Database (MySQL) pricing per database

      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 -
      1 answer19 days agoBy Anjanesh LekshminarayananDigitalOcean Managed MySQL Database
    • Question

      Database Error when logging into wordpress

      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 answers21 days agoBy Mohit PandeyDatabasesDigitalOcean Managed MySQL DatabaseMySQLWordPress
    • Question

      How to set timezon in managed database?

      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 answer23 days agoBy Heriberto SosaDigitalOcean Managed MySQL Database
    • Question

      Slow queries log on managed database

      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.
      1 answer23 days agoBy benDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      How to restore a website if data is corrupted

      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 answer1 month agoBy Mohit PandeyDigitalOcean DropletsDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      WP database present on SFTP but can't see it when I run SHOW DATABASES; on CLI

      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 answer1 month agoBy Mohit PandeyDatabasesDigitalOcean DropletsDigitalOcean Managed MySQL Database
    • Question

      "ERROR 1227 (42000) at line x: Access denied" when using doadmin user

      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 answers1 month agoBy Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Urgent: Your [placeholder] database’s functionality is at risk

      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 answers1 month agoBy Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      DNS server from Digital Ocean not always reachable resulting in getaddrinfo failed: Temporary failure in name resolution

      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 yet2 months agoBy Chris SeegersDigitalOcean Managed MySQL DatabaseDNSUbuntu 20.04
    • Question

      How to make Database Cluster Alert Policies work using tags and Slack

      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 yet2 months agoBy Max HeroldDigitalOcean Managed MySQL DatabaseDigitalOcean Managed PostgreSQL Database
    • Question

      The server requested authentication method unknown to the client [caching_sha2_password]

      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 answer2 months agoBy Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQLPHP
    • Question

      Can't connect to mysql database on mysql workbench, saying "Could not connect unknown authentication type"

      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 answer2 months agoBy DwikavindraDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      connection error or privileges to connect prestashop to database service

      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 answer2 months agoBy MassiveTealAnglerDigitalOcean Managed MySQL Database
    • Question

      Error when setting up MySQL migration from a droplet to a new Managed DB.

      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 answer3 months agoBy scottfriebelDatabasesDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Account Lockout Policy On Digital Ocean

      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 answer3 months agoBy Kingsley EkwuemeBuilding on DigitalOceanDigitalOcean Managed MySQL DatabaseSecurity