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 • 11 days 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 • 12 days 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 • 13 days 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 • 13 days 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 • 14 days 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 • 15 days 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 • 24 days 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 • 26 days 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 • 1 month 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 • 2 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 • 2 months ago • By Kingsley EkwuemeBuilding on DigitalOceanDigitalOcean Managed MySQL DatabaseSecurity
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 answer • 2 months ago • By boooooDigitalOcean Managed MySQL Database
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 ago • By Chris Sev, Darian WilkinDatabasesDigitalOcean Managed MySQL DatabaseDigitalOcean Managed PostgreSQL DatabaseDigitalOcean Managed RedisTech Talks
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 answer • 2 months ago • By accountsDigitalOcean Managed MySQL DatabaseSQL
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 answers • 3 months ago • By Nikola MilicDigitalOcean App PlatformDigitalOcean Managed MySQL DatabasePHPPHP Frameworks
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 answer • 3 months ago • By PrabhupadDigitalOcean Managed MySQL DatabaseLEMPMySQLNginxNode.jsPHP
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 answer • 3 months ago • By mr nastyDigitalOcean Managed MySQL DatabaseMySQL