Error connecting to database FATAL: password authentication failed for user "jiradbuser"

[Vick]

I have latest Jira 9.10 installed  | Postgresql 10.3 | Running on Redhat 8.8

CREATE USER jiradbuser;

CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

GRANT ALL PRIVILEGES ON DATABASE jiradb TO jiradbuser;

I changed "pg_hba.conf" to the following: host all all 127.0.0.1/32 md5

Database Type: PostgreSQL

Hostname: localhost

Port: 5432

Database: jiradb

Username: jiradbuser

Password: entered correct password and changed it too

Schema: public

I have made sure to restart postgresql service once changed to md5

[Vick · Accepted solution]

This worked for me

Changed --> /var/lib/pgsql/data/pg_hba.conf -

host | all | all | 127.0.0.1/32 | md5
host | all | all | 127.0.0.1/32 | password