Databases

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

    How to install the latest stable MariaDB version on CentOS 8?

    If you have a CentOS 8 server you might have noticed that installing MariaDB directly with the sudo dnf install mariadb-server command does not install the latest stable MariaDB version. Here’s how you could install t...
    Accepted Answer: Before getting started, make sure to follow our Initial Server Setup Guide for CentOS 8 guide: https://www.digitalocean.com/community/tutorials/initial-server-setup-with-centos-8 Also, make sure that you have wget ins...
    1 By bobbyiliev MariaDB MySQL Databases CentOS CentOS 8 Linux Basics Linux Commands
  • 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

    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

    How to get long term backups for DigitalOcean's Managed Databases (MySQL)?

    The documentation for Managed Databases states backups are only held for a week. I want to keep longer term backups, but can't make them manually without SSH access which Managed Databases don't give. Is there a way t...
    Accepted Answer: Hi there @visarunas, What I usually do is use a MySQL backup tool like mysqldump for example. It allows you to export your databases without SSH access. To export a backup you could run the following command: mysqldu...
    2 By visarunas DigitalOcean Managed MySQL Database Databases
  • Question

    Managed MySQL: Failed to create table

    Hello, I'm using Managed MySQL and the OpenLiteSpeed WordPress 1-Click image. Enabling some css or js options in the bundled LSCache plugin shows the following error: Failed to create table cssjs! SQL: CREATE TABLE I...
    Accepted Answer: Hi, What if you directly run CREATE TABLE IF NOT EXISTS `wp_litespeed_cssjs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `hash_name` varchar(60) NOT NULL COMMENT "hash.filetype", `src` text NOT NULL COMMENT "full url ...
    2 By PSNick DigitalOcean Managed MySQL Database OpenLiteSpeed WordPress 1-Click Databases
  • 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

    media files returns 404 not found

    my nginx file looks like: ``` location = /favicon.ico { accesslog off; lognot_found off; } location /static/ { alias /home/me/projectdir/static/; } location /media/ { alias /home/me/projectdir/media/; } locati...
    Accepted Answer: Hi there @elprincipe, Do you see any errors in your Nginx error log? You can check that with the following command: command,bash sudo tail -100 /var/log/nginx/error.log It is quite possible that Nginx does not have t...
    1 By elprincipe Nginx Python PostgreSQL Django Python Frameworks Ubuntu 18.04 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

    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

    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 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 DigitalOcean 1-Click Apps Marketplace 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

    How do I connect to a postgres connection pool with managed databases?

    We have decided to use Postgres and digital oceans managed databases for our next project. This database will handle about 10 million page visits a month, with certain points having spikes in traffic. We created a dat...
    Accepted Answer: To answer my own question, use the pool name to connect instead of the db name. postgresql://{user_name}:{password}@datalab-do-user-6674409-0.b.db.ondigitalocean.com:{pool_port_number}/{<^>pool_name<^>}?sslmode=requ...
    1 By gbland Databases PostgreSQL
  • 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 DigitalOcean 1-Click Apps Marketplace
  • 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'] = ...
    5 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

    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

    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