Databases

Databases subscription active
You will receive email notifications for new publications on Databases.
139 Results
  • Question

    How to change caching_sha2_password to mysql_native_password on a DigitalOcean's Managed MySQL Database?

    I want to use the new DigitalOcean MySQL Managed Databases with my PHP application but I'm getting this error here: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; con...
    Accepted Answer: Hello, The easiest way to fix that would be to alter your existing user with the following: ALTER USER <^>myuser <^>IDENTIFIED WITH mysql_native_password BY '<^>mypassword<^>'; Another thing that you could do is to ...
    6 By devdojo Databases MySQL PHP WordPress
  • Question

    Managed Databases Feedback: mySQL 8 was terrible product decision!

    Hello guys, I do not understand your decision to go with MySQL 8 instead of using the well established and widely used 5.7 branch when you created the product managed databases. I don't get it. The general idea of a h...
    Accepted Answer: MySQL support for 5.7 ends in a few months (Oct 2020), it would be bad decision to release a product that comes to EOL in less than 1 year. I would guess that this is the main reason why DigitalOcean decided to go wit...
    1 By ReneH DigitalOcean Databases
  • Question

    Cannot connect my postgresql db to my netcore project

    I want to use my postgresql db from digital ocean in my webpage. Before i create this db, i have a free one for test and is working fine, but this new its not working. I can connect from pgadmin to the db. My web proj...
    Accepted Answer: Hello, You would need to download the certificate for your PostgreSQL cluster via the DigitalOcean control panel and then upload it to your Droplet. You need to place the certificate at: ~/.postgresql/postgresql.crt...
    1 By PalumboWeb Databases PostgreSQL
  • Question

    How to configure Laravel 5.7 with Redis TLS (Using phpredis)

    Hi I'm using laravel 5.7 with phpredis (PHP 7.2), but I’m not able to get it to work with tls, I am trying to use it with digitalocean Redis managed database which only supports tls connections. Any idea if tls even s...
    Accepted Answer: So I managed to get this to work, basically the current phpredis version that is shipped with php 7.2 (Ubuntu 18) is old and does not support tls, to fix this I had to update phpredis from pecl (https://pecl.php.net/p...
    2 By ahmadt Redis Databases PHP PHP Frameworks
  • Question

    "Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7

    I've set up a new CentOS 7 server with Apache, MySQL and phpMyAdmin using Digital Ocean's guides. However, when I try to log in to phpMyAdmin via the browser, I get the message "Cannot log in to the MySQL server" with...
    Accepted Answer: Assuming MySQL 8. ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD'; Reason: Some applications are having trouble with <^>caching _sha2 _password<^> method. Above sets the credentials to use the...
    4 By NielsKersic MySQL Databases CentOS
  • Question

    How to connect into DB cluster with PhpMyAdmin ?

    I had DB cluster and was successfully connected remotely via new droplet with MySQL 8 installed on there. ``` root@confidential:~# mysql --version mysql Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL) r...
    Accepted Answer: Well lucky me i was able to figuring out the problem. it's the additional PhpMyAdmin configuration which cause the problem. After i'm editing the additional configuration became : $i++; $cfg['Servers'][$i]['host'] = ...
    2 By mangprangstore Databases PHP
  • Question

    Running asp.net Core 2.1, MS SQL Server on a droplet

    What would be the best way to run the setup above? Can they run without a docker on a linux machine?
    Accepted Answer: Hello, Yes you should be able to run that on an Ubuntu 16 droplet. To install MSSQL(mssql-server) follow these steps here: Become root: sudo su Import the public repository GPG keys: curl https://packages.microsoft...
    1 By Slothmachine Applications Databases
  • Question

    Can you scale up a database from a smaller size to a bigger one easily using managed databases?

    I'm working on a hobby project and right now I want to use the smallest available database size because I don't know if the project will go anywhere. My question is about whether down the line, if the project does en...
    Accepted Answer: Hello, Yes, you can just start with the smallest available database size and upgrade whenever you need to. Basically what happens when you scale up is that extra resources like RAM, CPU and etc are added to your datab...
    1 By muhammad Databases
  • Question

    Change Auth Type of User in DO MySQL Managed Database

    Hi all, Currently diving into the world of Kubernetes and thought I'd set up a managed database on Digital Ocean while I'm at it. I've set up Ghost (https://github.com/TryGhost/Ghost) no problem, and am trying to get ...
    Accepted Answer: Hello, What you could do is just create a new user with mysql_native_password. To do that you could use the following: CREATE USER 'your_user'@your_server_ip IDENTIFIED WITH mysql_native_password BY 'your_password'; ...
    1 By awildeocean DigitalOcean Ghost Databases MySQL
  • Question

    Unable to Move MySQL DB Location - Ubuntu 18.04.3 (LTS) x64

    I followed the steps below exactly and the MySQL service will not start. This is a new Droplet with NO pre-existing data. Reference:: https://www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directo...
    Accepted Answer: Nevermind. It seems I can't read... The KB works.
    2 By MattyBob Storage MySQL Databases Block Storage Ubuntu 18.04
  • Question

    Virtual Hosts not working

    After Setting Up my Virtual Hosts when i run [sudo apache2ctl configtest] i get this message below please how can i fix it ? AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, us...
    Accepted Answer: Hello, The message that you are getting is only a warning and would not prevent your Apache and Vhost from working. As long as you get the Syntax OK at the end then the Apache restart should work as normal. If your Vi...
    1 By nandommamdam PHP LAMP Stack MySQL Apache Databases Ubuntu 18.04
  • Question

    How to download a database from Managed Database Cluster?

    How to download a database from Managed Database Cluster (PostgreSQL)? And How to upload existing database to Managed Database Cluster (PostgreSQL)?
    Accepted Answer: Hi there @Motash, You should be able to achieve both of these by using the pg_dump and pg_restore command-line tools. A command similar to the following should allow you to dump all the data from your remote PostgreSQ...
    2 By Motash DigitalOcean Databases Ubuntu 18.04
  • Question

    Remote Mysql fail to connect - Tried everything I can think of.

    So I am going to walk you through everything I have done since I created this. Since this is a test before I run it for production. ssh in, change root password adduser (new user added) usermod -aG sudo (new user) ufw...
    Accepted Answer: I was unable to resolve this issue. Removing the droplet and closing ticket. Anyone that is curious all steeps I have taken are listed above. It is replicate-able by simply following those steeps.
    4 By quentinpidcock MySQL DigitalOcean Cloud Firewalls Firewall Databases DNS Ubuntu 18.04
  • Question

    CouchDB memory consumption rising over time

    I'm running a CouchDB (2.3.1) on Ubuntu 16.04 with 1GB of memory. While my Node Server constantly consumes around 35MB, the CouchDB memory usage increases over time (see my Droplets Memory Graph (https://ibb.co/z8WfNt...
    Accepted Answer: It is normal to see a database, including CouchDB increasing memory consumption over time. This is because as a database serves more requests it will cache more results. This way it can return the results faster. You ...
    1 By coffeerushapps Databases NoSQL Ubuntu 16.04
  • Question

    If I remove a database cluster which was a parent of another database cluster, will it affect a "child" database cluster?

    If I remove a database cluster which (its backup [Backups -> More -> Restore]) was a parent of another database cluster, will it affect a "child" (after "Restore") database cluster? I'm 99,9% sure that those two datab...
    Accepted Answer: Hi there Motash! Thanks for the question. Clusters created from another cluster (forks and clusters resulting from a restore-from-backup) are created as unique clusters. Deleting the parent in these cases will not aff...
    1 By Motash DigitalOcean Databases
  • Question

    Setting up Database Replication with multiple slaves

    I've followed the instructions here (https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql) to setup replication - it works great. I need to add a second slave that only rep...
    Accepted Answer: You should be able to follow the same steps for the second replica, just try adding this in your second slave's config: replicate_do_db = dbname, that way only this specific database should be replicated.
    1 By CMTiffani Databases Ubuntu 16.04
  • Question

    Locked out of MySQL

    So, I was playing around in the settings of phpMyAdmin on my DigitalOcean server. I looked at the security settings and saw the password hashing method dropdown. Being the idiot I was, I was making a social media app,...
    Accepted Answer: You might have to revert the changes to fix it or restore it using an older backup. I would suggest you get in touch with our support team and they will be happy to help you: https://www.digitalocean.com/company/cont...
    1 By eclipticthezzoomguy MySQL Databases Ubuntu 18.04
  • Question

    Will it ever be possible to tune our managed Postgres database by running ALTER SYSTEM commands?

    I am trying to run ALTER SYSTEM commands to tune my postgresql managed database, but those commands need to be ran by a superuser. Will we ever get access to this?
    Accepted Answer: Hey friend, Great question! Andy, Jason, and Andre briefly discussed this question on our Slack. I wanted to relay the answer. Right now there is no direct plan to expose that kind of ability, but we will definitely c...
    1 By jft PostgreSQL Databases
  • Question

    Any update on Managed PostgreSQL?

    Hi. I'm looking to deploy a new project over the next couple of weeks, and I need a Postgres database. I signed up for the Managed Database Services beta back in October, and I'll want to use it as soon as it becomes ...
    Accepted Answer: Managed PostgreSQL is available to all users as of Feb 14 2019. Read the announcement post here: https://blog.digitalocean.com/announcing-managed-databases-for-postgresql/ Find the product documentation here: https://...
    1 By markrendle PostgreSQL Databases
  • Question

    Managed Databases - Changing Ownership of backups or entire databases

    I have been testing the new Managed Databases feature and find it very exciting. In addition to my own projects, I can personally see using this for specific client work where the ownership of the database may have t...
    Accepted Answer: Hello there! Thanks for asking these questions. Right now there are no plans for any of these items, but we hear you loud and clear. We've heard similar from at least one other customer recently. Given the age of the ...
    1 By tjhilbig Backups Databases