How To Solve Aws Rds Issue: Psycopg2.operationalerror: Fatal: Password Authentication Failed For User "root"

Im using terraform and have built the infrastructure below: VPC with Public subnets ECS Fargate and ECR Public RDS instance in the public subnets I am using django as the backend

Solution 1:

You can't use the root database account with RDS databases. That is a reserved account that only Amazon has access to. You need to examine your RDS database configuration and figure out what your admin account name is.