HTTP 500 error code on an Amazon Lightsail instance. Error establishing a database connection

snir 2020-03-05 12:56:26 UTC #1

Keywords: WordPress - AWS - Technical issue - Other
Description:
Hello, my site became inaccessible yesterday morning, for no apparent reason.

I'm using Wordpress on an Amazon Lightsail instance.

I now have an HTTP 500 error code : Error establishing a database connection

guidejv.com

I tried to disable plugins with FileZilla, checked the wp-config file.

I switched to an instance with more storage.

I have this error message in my debug.log file:

PHP Warning: mysqli_real_connect (): (HY000 / 2002): No such file or directory in /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php on line 1633

Line 1633 in the wp-db file:

mysqli_real_connect ($ this-> dbh, $ host, $ this-> dbuser, $ this-> dbpassword, null, $ port, $ socket, $ client_flags);

I used the support tool here is the code:

e52723c1-7470-4564-adcf-723c488deb30

I ran out of ideas

davidg 2020-03-06 10:17:09 UTC #2

Hello @snir,

First, could you confirm you can access bitnami_wordpress database with the credentials in /opt/bitnami/apps/wordpress/htdocs/wp-config.php?:

sudo /opt/bitnami/mysql/bin/mysql -ubn_wordpress -pYOUR_PASSWORD bitnami_wordpress

This is a previous case really similar:

I hope it helps

snir 2020-03-06 13:49:59 UTC #3

Yes I have access to wp-config, I checked DB_User, DB_password, I changed DB_HOST to 127.0.0.1:3306 (before localhost: 3306)

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!