Error: Database connection failed

Question

Hi, I got this Error:

It is possible that the database is overloaded or otherwise not running properly.

The site administrator should also check that the database details have been correctly specified in config.php

Bobby · Answer

Hey Ismail, That message usually pops up when there’s a problem connecting to your database. It could be something as simple as a typo in your config.php, double-check the database name, username, password, and host just to be safe. Another common issue is that the database server itself isn’t running properly. If you’re on a Droplet, you can try restarting MySQL or PostgreSQL depending on what you’re using. And if your server is low on resources, it might be running out of connections, especially under load. You can check the status of your database by running sudo systemctl status mysql or sudo systemctl status postgresql depending on what you’re using. Another option is to move to a managed database service like DigitalOcean’s Managed Databases so you don’t have to worry about the database server itself: https://docs.digitalocean.com/products/databases/ If you’re not sure, feel free to share a bit more about your setup (what app you’re running, what kind of database, hosting details). - Bobby

KFSys · Answer

Heya, Database server is down Incorrect DB credentials in config.php Too many open database connections The database server is out of resources (RAM/CPU) Database permissions or networking issues Those are the possible causes of the problem you are seeing with the first 2 being the most common. Check if the database server is running If you’re using MySQL or MariaDB, run: sudo systemctl status mysql # or sudo systemctl status mariadb If it’s not running , start it: sudo systemctl start mysql Check database credentials in config.php Open your app’s config.php file: nano /path/to/your/app/config.php Look for: $CFG->dbhost = 'localhost'; // or an IP address $CFG->dbname = 'your_db_name'; $CFG->dbuser = 'your_db_user'; $CFG->dbpass = 'your_db_password'; Verify that: Host is correct (often localhost, but not always) User and password are accurate Database exists Test DB connection manually Run this in the terminal: mysql -u your_db_user -p your_db_name If this fails, double-check your username/password and permissions.

alexdo · Answer

Heya, @ismailjamil If your disk is full, the database may crash or refuse connections. Run: df -h If usage is near 100%, you can clean up logs or unused files. Also look at MySQL’s error log will give you the real reason why it’s not starting or failing connections: sudo cat /var/log/mysql/error.log Regards

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

Error: Database connection failed

Related questions

How Can I Deploy a Django Procurement App on Digitalocean App Platform, Maintain Local Database Backups, and Later Migrate to an InHouse Ser

How are you backing up your Droplets and databases on DigitalOcean?

Persistent 'SELF_SIGNED_CERT_IN_CHAIN' Error on Managed PostgreSQL Connection

connect already using mongodb atlas to digital ocean

how to connect digital ocean app platform app with cpanel mysql database?

What’s the best way to handle downtime during software deployments?

Locked out of my database

How to restart manage mongodb database

Postgres - Database extension pg_stat_statement is activ but table doesn't exists

Trying to connect to postgresql on droplet programmatically via python and pg8000/psycopg2

Can we use YugabyteDB as a supported engine in the database cluster?

Expand Disk Space of the Droplet for MySQL Galera Cluster

Report this

Error: Database connection failed

Related questions

How Can I Deploy a Django Procurement App on Digitalocean App Platform, Maintain Local Database Backups, and Later Migrate to an InHouse Ser

How are you backing up your Droplets and databases on DigitalOcean?

Persistent 'SELF_SIGNED_CERT_IN_CHAIN' Error on Managed PostgreSQL Connection

connect already using mongodb atlas to digital ocean

how to connect digital ocean app platform app with cpanel mysql database?

What’s the best way to handle downtime during software deployments?

Locked out of my database

How to restart manage mongodb database

Postgres - Database extension pg_stat_statement is activ but table doesn't exists

Trying to connect to postgresql on droplet programmatically via python and pg8000/psycopg2

Can we use YugabyteDB as a supported engine in the database cluster?

Expand Disk Space of the Droplet for MySQL Galera Cluster