Databases

Databases subscription active
You will receive email notifications for new publications on Databases.
302 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

    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

    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
  • Question

    Managed mysql database for small app

    Hello, we have a small application running on a droplet and this application receives an average of 160 requests / minutes and performs some CRUD operations on the database. In each request, a connection is opened wit...
    Accepted Answer: Hi there, I believe that 160 requests per minute should be OK, this is a little bit less than 3 queries per second. However, it really depends on the complexity of the queries and the amount of data. If you are doing ...
    1 By csalg12 DigitalOcean Managed MySQL Database MySQL Databases
  • 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: Hi there, Indeed as of the time being MongoDB is not offered as a managed database solution, but this might change soon. For the moment you could install MongoDB on a regular Droplet or use this 1-Click installation o...
    1 By abdelrahmanshahda MongoDB Node.js Databases
  • Question

    Database cluster constant connection

    Hey, I created a PostgreSQL database cluster. Since then, even with trusted sources set to any IP. I have a constant "1 connection". I don't know if this connection comes from Digital Ocean or a pending connection tha...
    Accepted Answer: Hi there, The connection you're seeing to the database might be the agent connection for system metrics. The max backend Connections are defined according to the cluster size and system or agent connections do not cou...
    1 By Kiyozz Databases DigitalOcean Managed PostgreSQL Database
  • 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 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

    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

    Manage DigitalOcean MySQL Database with MySQL Workbench - Reverse Engineer

    Hi, I am using Digital Ocean MySQL database service with MySQL workbench to manage it (Version 8.0.22 build 107600 CE 64 bit). I have succesfully connected to the database with MySQL workbench and can see my schema an...
    Accepted Answer: Asked DigitalOcean support and they managed to find a solution. Remove ANSI_QUOTES from Global SQL Mode for the managed database server and it worked for me.
    4 By johnnychenjiahao Databases MySQL DigitalOcean Managed MySQL Database
  • 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 to move Manticore Search data to another drive ?

    Hello, I want to move my Manticore Search data to a different drive. So far my searches have been unsuccessful. I will soon have a disk space problem if I don't move my data, so I need to be told the steps necessary t...
    Accepted Answer: Hello Your steps are correct. Changing Manticore Search configuration is super simple in this case: in Ubuntu you'll need to just update data_dir in /etc/manticoresearch/manticore.conf
    1 By florianbrgnr Databases
  • Question

    Can ScyllaDB cluster be deployed to DO without performance bottleneck?

    According to ScyllaDB hardware requirements (https://docs.scylladb.com/getting-started/system-requirements/#hardware-requirements) it needs network interface speed of 10 - 56 GB/s for production work loads, but as far...
    Accepted Answer: Hi! I’m honestly am not very familiar with ScyllaDB, but do know that our network speed is 2 GB/s for both Basic droplets and Dedicated droplets (General Purpose, CPU optimized, Mem optimized, Storage optimized).
    2 By kaushalyap Databases NoSQL Networking
  • 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

    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 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

    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

    How To Fix database error datasbase.wp_user doesn't exist for query

    I have tried to login in WordPress through WP-CLI but as I run wp-login, It shows "database error database.wp_user doesn't exist for query" and a bunch of other lines and I become unable to login. What can I do to fi...
    Accepted Answer: Hi there @newwayelegant, To me it looks like that either your database details are not correct in your wp-config.php file, you need to make sure that you use the correct database name, database username and password. ...
    1 By newwayelegant Databases DigitalOcean Managed MySQL Database WordPress OpenLiteSpeed WordPress 1-Click
  • 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