pg Admin 4 – password for “postgres” user when trying to connect to PostgreSQL 13 server

I ran into the same problem recently. The solution below works for me. I’m using Windows btw, so you should try equivalent commands in your OS. Change METHOD of all rows in your pg_hba.conf file from scram-sha-256 to trust Add bin folder of Postgres installation to path, if you haven’t Open command prompt and enter … Read more

Unable to connect to Postgres DB due to the authentication type 10 is not supported

I solved similar issue by applying below steps in PostgreSQL Version 13: Change password_encryption to md5 in postgresql.conf Windows: C:\Program Files\PostgreSQL\13\data\postgresql.conf GNU/Linux: /etc/postgresql/13/main/postgresql.conf Change scram-sha-256 to md5 in pg_hba.conf Windows: C:\Program Files\PostgreSQL\13\data\pg_hba.conf GNU/Linux: /etc/postgresql/13/main/pg_hba.conf host all all 0.0.0.0/0 md5 Change Password ( this restore password in md5 format). Example: ALTER ROLE postgres WITH PASSWORD ‘root’; … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)