HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMajor

PgAdmin III - How to connect to database when password is empty?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
pgadminconnectemptypassworddatabasehowiiiwhen

Problem

I have installed PostgreSQL 9.1 on my PC (Win 7). I have a small Java application connecting successfully to it with login=sa and password="". The connection works.

However, it is refused from PgAdmin III itself. I get:

Error connecting to the server: fe_sendauth: no password supplied


How do I connect to my database from PgAdmin III with an empty password?

EDIT

This is just a test, not production code.

Solution

I found this answer elsewhere.

If your DB is on the local host, try leaving the host field blank in the connection as opposed to using “localhost” or “127.0.0.1″. This tells PgAdmin to connect via the local unix socket instead of TCP.

Context

StackExchange Database Administrators Q#8111, answer score: 33

Revisions (0)

No revisions yet.