snippetsqlMajor
PgAdmin III - How to connect to database when password is empty?
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
However, it is refused from PgAdmin III itself. I get:
How do I connect to my database from PgAdmin III with an empty password?
EDIT
This is just a test, not production code.
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 suppliedHow 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.
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.