AWS error establishing a database connection

Remote Linux Server Administrator
Server Management Service

Are you trying to fix the AWS error establishing a database connection?

This guide will help you.

AWS Error establishing a database connection happens as a result of different reasons that include corrupt MySQL, webserver down, bot hitting the server load, and so on.

Here at Ibmi Media, as part of our Server Management Services, we regularly help our Customers to resolve AWS related errors.

In this context, we shall look into methods to tackle this error.

Tips to fix AWS error establishing a database connection ?

Apply the following tips to resolve this error.

1. Install load balancer

Recently, one of our customers approached us saying that after moving the WordPress blog to to Amazon EC2, he received the below error:

error establishing a database connection

Here, we found that the server load was high.

On further investigation, we could find that some bot requested the website due to which there was high number of connections.

As a result, the SQL database could not serve the load.

Thus, we installed a load balancer.

That resolved the error.

2. Try rebooting the instance can also resolve the error magically.

3. Sometimes, restarting the MySQL service can also help resolve the error.

Here is the command for it:

sudo service mysqld restart

4. If the culprit is not the MySQL service, then webserver like Apache can also cause issues.

So we suggest to reboot it as well:

sudo service httpd restart

[Need urgent assistance in fixing AWS errors – We are here to help you. ]

Conclusion

AWS error establishing a database connection happens as a result of different reasons that include corrupt MySQL, webserver down, bot hitting the server load, and so on.

AWS Error establishing a database connection means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server.

This could mean your host's database server is down.

Are you sure you have the correct username and password?

Are you sure that you have typed the correct hostname?

Are you sure that the database server is running?

The inability to connect to an Amazon RDS DB instance can have a number of root causes. The wrong DNS name or endpoint was used to connect to the DB instance.

The Multi-AZ DB instance failed over, and the secondary DB instance uses a subnet or route table that doesn't allow inbound connections.