Error establishing a database connection - Lightsail & Wordpress

Hi all,

I'm new to AWS and decided to start the project of migrating my website to AWS Lightsail. I followed all the steps on the process suggested by Amazon, however after 2 days, my site is still offline and the following message appeared yesterday night:

• Error establishing a database connection (this happens when I enter my site cuentaovejaszzz.com)
• Error establishing a database connection This either means that the username and password information in your wp-config.php file is incorrect or that contact with the database server at 127.0.0.1:3306 could not be established. This could mean your host’s database server is down. (this message appears when I enter using the static IP/wp-admin)*

I already restored the backup file of my old site into the new WP dashboard, but now I can't enter to it. I checked the wp-config.php since read that this may be a user/password issue, but I changed the hash password to the one provided on the Bitnami console, however still the issue persists.

Please any advice on how to overcome this issue will be highly appreciated.

Thanks in advance

WP-CONFIG.PHP file code `<?php //Begin Really Simple SSL session cookie settings @ini_set('session.cookie_httponly', true); @ini_set('session.cookie_secure', true); @ini_set('session.use_only_cookies', true); //END Really Simple SSL cookie settings

define( 'WP_CACHE', true ); // Added by WP Rocket

• This file contains the following configurations:

• • Database settings
• • Secret keys
• • Database table prefix
• • ABSPATH

• @link https://wordpress.org/documentation/article/editing-wp-config-php/

• @package WordPress

*/

// ** Database settings - You can get this info from your web host ** //

/** The name of the database for WordPress */

define( 'DB_NAME', 'bitnami_wordpress' );

/** Database username */

define( 'DB_USER', 'bn_wordpress' );

/** Database password */

define( 'DB_PASSWORD', 'PRIVATE INFO' );

/** Database hostname */

define( 'DB_HOST', '127.0.0.1:3306' );

/** Database charset to use in creating database tables. */

define( 'DB_CHARSET', 'utf8' );

/** The database collate type. Don't change this if in doubt. */

define( 'DB_COLLATE', '' );

/**#@+

• Authentication unique keys and salts.

• Change these to different unique phrases! You can generate these using

• the {@link https://api.wordpress.org/secret-key/1.1/salt/ WordPress.org secret-key service}.

• You can change these at any point in time to invalidate all existing cookies.

• This will force all users to have to log in again.

• @since 2.6.0

*/

define( 'AUTH_KEY', 'PRIVATE INFO' );

define( 'SECURE_AUTH_KEY', 'PRIVATE INFO' );

define( 'LOGGED_IN_KEY', 'PRIVATE INFO' );

define( 'NONCE_KEY', 'PRIVATE INFO );

define( 'AUTH_SALT', 'yb/::Q:tQA{}YPcX6E$rv!B?A _c8.Hs` az-]fFz@b}u^][tSc@FTSCz^tQ*I' );

define( 'SECURE_AUTH_SALT', 'PRIVATE INFO' );

define( 'LOGGED_IN_SALT', 'PRIVATE INFO' );

define( 'NONCE_SALT', 'PRIVATE INFO' );

/**#@-*/

/**

• WordPress database table prefix.

• You can have multiple installations in one database if you give each

• a unique prefix. Only numbers, letters, and underscores please!

*/

$table_prefix = 'wp_';

/**

• For developers: WordPress debugging mode.

• Change this to true to enable the display of notices during development.

• It is strongly recommended that plugin and theme developers use WP_DEBUG

• in their development environments.

• For information on other constants that can be used for debugging,

• visit the documentation.

• @link https://wordpress.org/documentation/article/debugging-in-wordpress/

*/

define( 'WP_DEBUG', false );

/* Add any custom values between this line and the "stop editing" line. */

define( 'FS_METHOD', 'direct' ); /**

• The WP_SITEURL and WP_HOME options are configured to access from any hostname or IP address.
• If you want to access only from an specific domain, you can modify them. For example:
• define('WP_HOME','http://example.com');
• define('WP_SITEURL','http://example.com');

*/ if ( defined( 'WP_CLI' ) ) { $_SERVER['HTTP_HOST'] = '127.0.0.1'; }

define( 'WP_HOME', 'http://' . $_SERVER['HTTP_HOST'] . '/' ); define( 'WP_SITEURL', 'http://' . $_SERVER['HTTP_HOST'] . '/' ); define( 'WP_AUTO_UPDATE_CORE', 'minor' ); /* That's all, stop editing! Happy publishing. */

/** Absolute path to the WordPress directory. */

if ( ! defined( 'ABSPATH' ) ) {

define( 'ABSPATH', __DIR__ . '/' );

}

/** Sets up WordPress vars and included files. */

require_once ABSPATH . 'wp-settings.php';

/**

• Disable pingback.ping xmlrpc method to prevent WordPress from participating in DDoS attacks
• More info at: https://docs.bitnami.com/general/apps/wordpress/troubleshooting/xmlrpc-and-pingback/ */ if ( !defined( 'WP_CLI' ) ) { // remove x-pingback HTTP header add_filter("wp_headers", function($headers) { unset($headers["X-Pingback"]); return $headers; }); // disable pingbacks add_filter( "xmlrpc_methods", function( $methods ) { unset( $methods["pingback.ping"] ); return $methods; }); } `