DigitalOcean Managed MySQL Database

Subscribe to DigitalOcean Managed MySQL Database
Get notified when new articles on DigitalOcean Managed MySQL Database are published.
    All
  • 20 Results
    • 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 answer11 days 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 answer12 days 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 answers13 days 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 answers13 days 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 yet14 days 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 yet15 days 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 answer24 days 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 answer26 days 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 answer1 month 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 answer2 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 answer2 months agoBy Kingsley EkwuemeBuilding on DigitalOceanDigitalOcean Managed MySQL DatabaseSecurity
    • Question

      I can't open phpmyadmin url

      Hi, I have a droplets, app installed successfully, website is normal, but i can’t open phpmyadmin url, show does not exist. what should I do? Thanks,
      2 answers2 months agoBy AngeloDigitalOcean Managed MySQL DatabaseLoggingMySQL
    • Question

      Optimal way to replicate a MANAGED DO MYSQL DB to other DBs, such as localhost or any other DB with a connection

      I want to mirror my main database to my localhost so I have similar data throughout my development environment. Curious what the best way to do that with a managed DB, because I don’t have access to SSH so i can’t fol...
      1 answer2 months agoBy boooooDigitalOcean Managed MySQL Database
    • Tech Talk

      Migrating Your Database to DigitalOcean With Minimal Downtime

      Self-hosting getting out of hand? Paying too much for a managed database? Migrate your MySQL, PostgreSQL, and Redis database to DigitalOcean’s hassle-free databases.
      2 months agoBy Chris Sev, Darian WilkinDatabasesDigitalOcean Managed MySQL DatabaseDigitalOcean Managed PostgreSQL DatabaseDigitalOcean Managed RedisTech Talks
    • Question

      Import existing database.

      ERROR 3750 (HY000) at line 31: Unable to create or change a table without a primary key, when the system variable ‘sql_require_primary_key’ is set. Add a primary key to the table or unset this variable to avoid this m...
      1 answer2 months agoBy accountsDigitalOcean Managed MySQL DatabaseSQL
    • Question

      PHP migration with managed MySQL

      Hello, When I try to run migrations on App Platform during deploy, php artisan migrate --force, I get the following error even though I granted for db_user: SELECT, GRANT OPTIONS on information_schema, and GRANT ALL o...
      2 answers3 months agoBy Nikola MilicDigitalOcean App PlatformDigitalOcean Managed MySQL DatabasePHPPHP Frameworks
    • Question

      [Warning] [MY-013712] [Server] No suitable 'keyring_component_metadata_query' service implementation found

      I was checking the logs on my database resource and see a lot of these errors. What are they? Should DO be handling them or do I need to do something?
      1 answer3 months agoBy Vishal ApteDigitalOcean Managed MySQL Database
    • Question

      Unable to connect Node.JS to MySql on same ubuntu machine. Timeout error/ConnectionRefused.

      I have written a Node.Js Application for demo purpose to connect to DB. I ma new to DO platform and connecting remote servers. The Node.Js application that I have written, I am able to connect to MySQL DB (present/usi...
      1 answer3 months agoBy PrabhupadDigitalOcean Managed MySQL DatabaseLEMPMySQLNginxNode.jsPHP
    • Question

      Regarding MYSQL database connection limits, How long does 1 connection last?

      I am trying to work out how much RAM I need for a MYSQL database based off the 75 simultaneous connections per 1GB ram rule. If one connection was made to a MYSQL database how long would it be classed as connected? Is...
      1 answer3 months agoBy mr nastyDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      mysqldump managed database through cron

      From https://docs.digitalocean.com/products/databases/mysql/how-to/import-databases/#export-with-mysqldump I got below:mysqldump -u doadmin -p -h mysql-test-do-user-4915853-0.db.ondigitalocean.com -P 25060 --single-tr...
      1 answer3 months agoBy mnaslundDigitalOcean Managed MySQL Database