FATAL: password authentication failed for user

Question

I use this tutorial with Python 3.5, Django 1.9, Linux Mint and PostgreSQL 9.3. But when I try "manage.py migrate" I have an error:

django.db.utils.OperationalError: FATAL:  password authentication failed for user "myprojectuser"

My database settings:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'myproject',
    'USER': 'myprojectuser',
    'PASSWORD': 'xxxxx',
    'HOST': 'localhost',
    'PORT': '',
}}

Is the password the correct one? Are you able to login in psql using the same credentials? — Evans Murithi
– Evans Murithi, Commented Dec 24, 2016 at 19:58
When I type "psql -d myproject -U myprojectuser" I have error: 'psql: FATAL: Peer authentication failed for user "myprojectuser"' — Evgeny Krasyuk
– Evgeny Krasyuk, Commented Dec 24, 2016 at 20:18
I think this askubuntu.com/questions/820792/… will solve your problem — Evans Murithi
– Evans Murithi, Commented Dec 24, 2016 at 20:26
Now I can login in psql using this username and password. But when I make 'manage.py migrate' I have the same error: password authentication failed for user "myprojectuser" — Evgeny Krasyuk
– Evgeny Krasyuk, Commented Dec 24, 2016 at 20:42
You can try with database url like: 'default': "postgres://myprojectuser:[email protected]:5432/myproject" — Evans Murithi
– Evans Murithi, Commented Dec 24, 2016 at 20:54

Amin Etesamian · Accepted Answer · 2016-12-24 19:59:25Z

1

its fairly self-explanatory, are the database password setting and the postgres user setting equal?

open a terminal and sudo -i -u postgres psql then do alter user myprojectuser with encrypted password xxxxx; set password equal to the value of password in your settings dict

'default': {
'PASSWORD': 'xxxxx',
}

answered Dec 24, 2016 at 19:59

Amin Etesamian

3,7275 gold badges30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amin Etesamian Over a year ago

its odd! I suggest you do a fresh start

Collectives™ on Stack Overflow

FATAL: password authentication failed for user

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related