Databases

Databases subscription active
You will receive email notifications for new publications on Databases.
368 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 bitmap Databases MySQL PHP WordPress
  • Question

    Can't access CouchDB admin page even though DB is available and working for the website

    I have a droplet running on 134.209.82.229 However if I try to access the control panel :5984/_utils/ for my running CouchDB it times out always. I can confirm that: port 5984 is open with ALLOW EVERYWHERE and "netsta...
    Accepted Answer: Hi there, I have just tried accessing the CouchDB installation and it seems to be working as expected. What I could suggest is to make sure that you do not have a local firewall either installed on your laptop on your...
    1 By pcmoreno DigitalOcean Droplets Databases Ubuntu 20.04
  • Question

    Floating IPs for managed database?

    I have setup a postgresql database cluster to do some testing. I tried to restore from a backup. This created a second cluster. Can somebody explain which database cluster is now the primary one? The original cluster ...
    Accepted Answer: Hello, The DigitalOcean Managed Databases automatically handle recovery from hardware and software failures by replacing degraded nodes with new ones that resume directly from the point of failure. This does not inclu...
    1 By rolandbergerAngler Databases
  • Question

    How to Find the Disk Usage in Managed Databases

    I Have a DO managed Database with the Specifications Bellow 4 GB RAM / 2vCPU / 38 GB Disk / Primary only / BLR1 - MySQL 8 where can we find the Disk Utilization of the Managed Database Database. I have already checked...
    Accepted Answer: Hi @KILAAdmin You can monitor cluster load and resources utilization metrics from the cloud panel. There are two kinds of metrics: Cluster metrics monitor the performance of the nodes in a database cluster. Cluster m...
    2 By KILAAdmin DigitalOcean Managed MySQL Database Databases
  • Question

    Does the price works the same for managed databases as for droplets?

    Hello! I'm still learning and trying out things, so I want to use only a bit of the Digital Ocean services. With droplets, I can use them for limited amount of time, like an hour, take a snapshot and just delete it. S...
    Accepted Answer: Hello @rafaeltragueta79 , That's a good query and similar to Droplets, you will also be charged per hour basis. Billing will be based on the hours of usage alone. Hope this helps! Cheers, Sri Charan
    2 By rafaeltragueta79 Databases Payments
  • Question

    Error in importing mysql file using command line

    Thank you for these useful commands I try to import a large SQL file but I have this error <b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b>C:inNMPWW I tried to increase maxexecutiontime in...
    Accepted Answer: mysql -u root -p xxxxdb < xxxdb_file.sql
    1 By anasalpure Ubuntu MySQL MariaDB Databases CentOS Debian Backups
  • 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 retrieve database credentials and certificate in Terraform?

    I'm using the DigitalOcean Terraform Provider (https://registry.terraform.io/providers/digitalocean/digitalocean) to set up my infrastructure, and I would like to set up a MongoDB database inside a cluster for each en...
    Accepted Answer: Hi @yuriEel, Terraform identified a bug where users getting MongoDB user password attribute empty and creating connection issues. This might be the reason you're not getting credentials for MongoDB via Terraform. For...
    1 By yuriEel Terraform MongoDB Databases
  • Question

    setup multiple databases on one postgres server with different users for each

    Hi I am using the digital ocean managed database, but I wanna be able to host more then one database, for more then one application at once, for security I want to restrict each database to a specific user and then ad...
    Accepted Answer: Hi there, Yes, this is doable. You can do this by modifying the user privileges. You can follow the steps on how to do that here: https://docs.digitalocean.com/products/databases/postgresql/how-to/modify-user-privileg...
    1 By aluf DigitalOcean Managed PostgreSQL Database PostgreSQL Databases
  • Question

    Returning A View To My Laravel App

    I have a music blog which I have developed using laravel 7 php framework, and I am using digital ocean spaces to store music files. Now I just need your help to show me how I can fetch the music stored on digital ocea...
    Accepted Answer: Hi there, Once you've uploaded the file and set the permissions correctly, you could access the file by using the Storage facade: Storage::disk('<^>spaces<^>')->url($your_file) If the name of your S3 disk is not '<^...
    1 By nathanmwamba2002 DigitalOcean Spaces Databases
  • Question

    Configuring a Private Rippled Server on DigitalOcean Droplet

    Hi! So I am part of a team that is working on the XRP Ledger in order to work with NFTs and cryptocurrency transactions. Part of this includes running a rippled server that can act as a validator which is necessary fo...
    Accepted Answer: Hi there, Uploading the server directly is most likely not doable due to the different operating systems. What you could do is to set up the server from scratch on your Ubuntu Droplet as per the official instructions ...
    1 By j93hahn DigitalOcean Droplets Building on DigitalOcean DigitalOcean VPC Databases Programming Project
  • Question

    attempt to write a readonly database in django app hosting on apache2 with db.sqlite3 database in ubuntu

    I was hosting django app on apache server with db.sqlite3 database, when i complete my hosting according your website guidance. and when i open mysite then i got this error.. OperationalError at / attempt to write a...
    Accepted Answer: Hi there @akshaykoshti401, What are the permissions of your SQLite file? To check that run ls -lah inside the directory where you store your database file. You need to make sure that the file is owned by the apache us...
    2 By akshaykoshti401 Apache Databases Django
  • 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

    trying to install mysql but I cannot start the service and cannot locate mysqld.sock

    I'm trying to install mysql but I cannot start the service and cannot locate mysqld.sock I am following the how to here: https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-sta...
    Accepted Answer: Hi there @dezshredder, To me it looks like that your MySQL service is stuck in a crash loop as the status output that you've shared indicates that the status is: "Server startup in progress" and the uptime is 15 secon...
    3 By dezshredder Ubuntu MySQL Ubuntu 18.04 Databases
  • Question

    I cant access my cpanel and WHM homepage

    Hi, I have a Cpanel & WHM droplet and my VA is migrating my websites from a shared account to digital ocean using Cpanel. He asked me to increase the disk space and so I did, now we can't access the Cpanel or WHM page...
    Accepted Answer: Hello, @Anapereira What you can do is examine the Apache error_log and track down any listed errors in the log. You can use the following command to get the last 100 entries of the log: command tail -n 100 /usr/local...
    1 By Anapereira CentOS DNS Databases
  • Question

    Create a dynamic database for each user using PHP

    Any suggestions on how we can create dynamic database for each user using PHP (as an when they register)? I am using the below code - it works on the local server, but not working in the live server on digitalocean. I...
    Accepted Answer: Hi there, Yes indeed if you are not using the root MySQL user it could be related to the privileges of the non-root user that you are using. What you could do is grant the user privileges to either all databases or be...
    1 By steveDolphin Databases PHP
  • Question

    MongoDB database price

    So I am searching for my options to host my mongodb database for production. I am looking for the least price hosting service which obviously has backup. I found that digitalOcean has what is called by Managed databas...
    Accepted Answer: Hello, DigitalOcean now offers Managed MongoDB databases as well: https://www.digitalocean.com/blog/introducing-digitalocean-managed-mongodb/ For more information on how to get started, make sure to check out this vid...
    2 By abdelrahmanshahda MongoDB Node.js Databases
  • Question

    How to set up SSH connection from remote database cluster to MySQL workbench

    I have a MySQL database cluster set up that I can connect to successfully via the command line (by running the flags in the terminal). I'd like to be able to connect to the MySQL Workbench. I looked at this tutorial (...
    Accepted Answer: Hi there, The tutorial with the remote MySQL connection via SSH would not work for Managed MySQL Clusters as the clusters do not come with SSH access. The tutorial would work if you had MySQL installed on a regular Dr...
    1 By jjustinjaeger MySQL DigitalOcean Managed MySQL Database Databases
  • Question

    Using App Platform database env variables

    As I was looking into the environment variables documentation (https://www.digitalocean.com/docs/app-platform/how-to/use-environment-variables/#component-specific-variables) for App Platform, I could not understand wh...
    Accepted Answer: @gabrielbottari 👋 The bindable variables (https://www.digitalocean.com/docs/app-platform/how-to/use-environment-variables/#using-bindable-variables-within-environment-variables) are meant to be used directly in the va...
    1 By gabrielbottari Node.js DigitalOcean App Platform Databases
  • Question

    MySql Master/Slave replication

    Hi, is it possible to replicate only selected tables with MySql Master/Slave replication?
    Accepted Answer: Hi @marcoSnorkler, As the master-slave replication is a one-way replication (from master to slave), only the master database is used for the write operations, while read operations may be spread on multiple slave data...
    1 By Raptortech Databases