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