Special Content

Home Science, Programming and Technology WordPress Wordpress AWS Error establishing a database connection

WordPress AWS Error establishing a database connection

June 12, 20231 Views

In one of my project, I am getting this error while accessing the website.

When I restarted RDS instance, the problem was solved and website was running.

After 2 days, again I am getting the same error. But after restarting RDS, Problem is solved. I am not able to figure out this problem. Please help.

Post Views: 1

2 comments

Anonymous says:

June 12, 2023 at 10:19 am

Look at this tutorial, it covers the whole process but you may skip to the last part: Using Amazon RDS with your WordPress installation
Anonymous says:

June 12, 2023 at 10:19 am
I had the same issue with AWS Lightsail.

Solved as follows :
- Checking of database instance service, MariaDB or MySql
  (https://aws.amazon.com/premiumsupport/knowledge-center/lightsail-wordpress-fix-database-errors/):
test ! -f "/opt/bitnami/common/bin/openssl" && echo "Approach A" || echo "Approach B"

test -d /opt/bitnami/mariadb && echo "MariaDB" || echo "MySQL"
- Then, check that WordPress has the right credentials for the DB_USER and DB_PASSWORD as set from database instance
  (https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-connect-wordpress-to-mysql-managed-database):
- Then, restart the Apache service
  (https://linuxize.com/post/start-stop-restart-apache/)
sudo systemctl restart apache2 or sudo service apache2 restart

Comments are closed.