Databases

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

    How do I use Digital Ocean to host a mini private game server?

    I am interested in put together a quick game server to test this Unity Asset = MMORPG KIT (2D/3D/Survival) (https://assetstore.unity.com/packages/templates/systems/mmorpg-kit-2d-3d-survival-110188) Based on the tip f...
    Accepted Answer: Hey @TeachMeGameServer, You are a lucky man! In their documentation, there is a section specifically for DigitalOcean. Take a look and let me know if that was helpful: https://suriyun-production.github.io/mmorpg-kit-d...
    2 By TeachMeGameServer Initial Server Setup Databases
  • 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 bitmap Databases MySQL PHP WordPress
  • Question

    How to upgrade MySQL server, for the one-click app

    Hello, I'm using the PHPMyAdmin one-click app, but the MySQL server version is way behind and I'm not sure how to upgrade it without breaking anything The current version is: mysql Ver 14.14 Distrib 5.7.30, for Lin...
    Accepted Answer: Hi there @Geekologist, With the PHPmyAdmin 1-Click installation, you get MySQL 5.7 and PHPmyAdmin 4.6.6. I believe that if you upgrade your MySQL installation you would need to upgrade PHPmyAdmin to the latest version...
    1 By Geekologist PHP MySQL One-Click Install Apps Ubuntu Ubuntu 18.04 Databases DigitalOcean
  • Question

    Setting up a database server on another droplet in VPC

    Hi. I am currently running database and web server on single droplet, but because of site traffic increase, I am planning to put database on separate droplet with enough RAM, but there are some questions: 1) I want my...
    Accepted Answer: Hi @xrjMaker, It's totally possible what you are aiming for and I believe if the traffic to your application is huge that it's a step in the right direction! Let's start with your questions. Private Networking is a re...
    1 By xrjMaker Scaling Networking Databases
  • 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

    If I use one-click to create an application, like the Open Source Social Network, do I have to manually install/configure a database first?

    Is a databae automatically installed and configured as part of the one-click install? Or is this a manual process? I assume the database can also run inside the droplet?
    Accepted Answer: Hi there! Many 1-Click Apps have databases installed, although there are some cases where you'll need to input a few things after you create that 1-Click App to complete the configuration of the database. Marketplace...
    1 By YurkshireLad Databases One-Click Install Apps
  • 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

    Need help understanding load balancing and which database solution to use

    Our wordpress web site is going to go live and will receive possibly 23 million hits in one day. Need help making sure we are ready for this.
    Accepted Answer: Hi, @jcooksey I will try to be helpful as possible here. Let's make some calculations first: for an average of 23 Million hits in one day, these are: * 959k hits per hour or * 15,983 hits per minute or * 266 hits per...
    1 By jcooksey Databases Load Balancing
  • Question

    Connection timed out on MySQL Managed Database Cluster

    Hi guys, we start up with a new Managed Database MySQL cluster but unfortunately we cant connect with any PHP tool AND also phpMyAdmin. The config for the phpMyAdmin: ``` $cfg['Servers'][$i]['verbose'] = 'CLUSTER'; $c...
    Accepted Answer: Failed with; $cfg['Servers'][$i]['port'] = 3306; Success with; -P 25060 You're simply using the wrong port in your application. Try changing it to the latter and retry connection. BR A
    2 By goetzm Databases MySQL Clustering DigitalOcean Managed MySQL Database
  • 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'] = ...
    4 By mangprangstore Databases PHP
  • 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

    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

    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

    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

    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

    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

    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...
    2 By nandommamdam PHP LAMP Stack MySQL Apache Databases Ubuntu 18.04
  • 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

    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