Multi-tier wordpress Error establishing a database connection

Keywords: WordPress - Google Cloud Platform - Technical issue - Services (Apache, MariaDB, MySQL…)

bndiagnostic ID: ccdec8f9-ab0f-e214-2410-9565edb8081f

bndiagnostic output:

? Connectivity: Found possible issues
https://docs.bitnami.com/general/faq/administration/use-firewall/

bndiagnostic failure reason: The suggested guides are not related with my issue

Description:
node0 server can’t connect node1 database server, have checked mariadb logs, got:
2022-06-19 5:33:34 867 [Warning] Access denied for user ‘bn_wordpress’@‘10.152.0.212’ (using password: YES)

the node0 ip address is 10.152.0.212
the database server runs on node1: 10.152.0.211

When I ssh login node1 database server and try access mariadb, got:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

How can I fix it?

Hi @leon.d,

Are you connecting with this command?

mysql -h SERVER-IP -u root -p

You can find more information in this guide:

https://docs.bitnami.com/aws-templates/apps/wordpress/administration/connect-remotely-mysql/

Regards,
Michiel