Error map

28P01 PostgreSQL: FATAL: password authentication failed for user

PostgreSQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (9). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.

28P01 — PostgreSQL: FATAL: password authentication failed for user (PostgreSQL)28P011045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)1045could not connect — PostgreSQL: could not connect to server / connection refused — Is the server running on host and accepting TCP/IP connections? (PostgreSQL)could not connect1698 — MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost' (MySQL)16981130 — MySQL ERROR 1130 (HY000): Host 'x' is not allowed to connect to this MySQL server (MySQL)113018456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)1845642P01 — PostgreSQL: ERROR: relation "x" does not exist (PostgreSQL)42P01SSL required — server does not support SSL, but SSL was required / no pg_hba.conf entry … no encryption (PostgreSQL)SSL required42501 — PostgreSQL: ERROR: permission denied for table / schema public (PostgreSQL)42501role does not exist — FATAL: role "x" does not exist (PostgreSQL)role does not exist1044 — MySQL ERROR 1044 (42000): Access denied for user to database (MySQL)10442002 — MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket (MySQL)20022006 — MySQL ERROR 2006 (HY000): MySQL server has gone away (MySQL)2006ECONNREFUSED — Error: connect ECONNREFUSED 127.0.0.1:5432 (Node.js)ECONNREFUSEDPrisma P1001 — Error: P1001: Can't reach database server at `host`:`5432` (Node.js)Prisma P1001SequelizeConnectionRefusedError — SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:5432 (Node.js)SequelizeConnection…caching_sha2_password — Authentication plugin 'caching_sha2_password' cannot be loaded (MySQL)caching_sha2_passwo…ORA-01017 — ORA-01017: invalid username/password; logon denied (SQL)ORA-010171142 — MySQL ERROR 1142 (42000): SELECT command denied to user 'x'@'host' for table 'y' (MySQL)11421227 — MySQL ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation (MySQL)12272003 — MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111) (MySQL)2003245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115544 — SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF. (SQL)5441146 — MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist (MySQL)114642703 — PostgreSQL: ERROR: column "x" does not exist (PostgreSQL)427031051 — MySQL ERROR 1051 (42S02): Unknown table 'x' (MySQL)1051CERTIFICATE_VERIFY_FAILED — SSL: CERTIFICATE_VERIFY_FAILED / unable to get local issuer certificate (API)CERTIFICATE_VERIFY_…3D000 — FATAL: database "x" does not exist (PostgreSQL)3D00053300 — FATAL: sorry, too many clients already / remaining connection slots are reserved for non-replication superuser connections (PostgreSQL)53300EACCES — Linux: Permission denied (Linux)EACCEScreate extension denied — ERROR: permission denied to create extension "x" — Must be superuser to create this extension. (PostgreSQL)create extension de…

Directly related (9)

1045MySQL

MySQL ERROR 1045 (28000): Access denied for user

MySQL rejected the login — wrong password, wrong user/host combination, or the user doesn’t exist.

could not connectPostgreSQL

PostgreSQL: could not connect to server / connection refused — Is the server running on host and accepting TCP/IP connections?

The client reached no PostgreSQL listener at that host/port — the server is down, listening elsewhere, or not accepting remote co…

1698MySQL

MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost'

root uses the auth_socket/unix_socket plugin (Ubuntu/Debian default), so password logins as root fail.

1130MySQL

MySQL ERROR 1130 (HY000): Host 'x' is not allowed to connect to this MySQL server

No MySQL account exists for the host you’re connecting from.

18456SQL

SQL Server: Login failed for user 'x'. (Error 18456)

SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.

42P01PostgreSQL

PostgreSQL: ERROR: relation "x" does not exist

The table/view isn’t found — missing migration, wrong schema, or a case-sensitive quoted name.

SSL requiredPostgreSQL

server does not support SSL, but SSL was required / no pg_hba.conf entry … no encryption

The client and server disagree about SSL — the client requires it but the server doesn’t offer it, or the server requires it and…

42501PostgreSQL

PostgreSQL: ERROR: permission denied for table / schema public

The role is connected but lacks privileges on that table or schema — very common after PostgreSQL 15 removed CREATE on the public…

role does not existPostgreSQL

FATAL: role "x" does not exist

PostgreSQL has no login role with that name.

Two steps away (22)

1044MySQL

MySQL ERROR 1044 (42000): Access denied for user to database

The login succeeded, but the user has no privileges on the database you’re using.

2002MySQL

MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket

The client couldn’t reach the MySQL server — it isn’t running, or the client is looking for the socket/port in the wrong place.

2006MySQL

MySQL ERROR 2006 (HY000): MySQL server has gone away

The connection to MySQL was closed — usually by a timeout or a packet larger than `max_allowed_packet`.

ECONNREFUSEDNode.js

Error: connect ECONNREFUSED 127.0.0.1:5432

Nothing is listening at that host:port — the target service is down or you’re connecting to the wrong address.

Prisma P1001Node.js

Error: P1001: Can't reach database server at `host`:`5432`

Prisma couldn’t connect to the database in DATABASE_URL.

SequelizeConnectionRefusedErrorNode.js

SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:5432

Sequelize couldn’t connect to the database server.

caching_sha2_passwordMySQL

Authentication plugin 'caching_sha2_password' cannot be loaded

An old MySQL client/driver can’t use MySQL 8’s default authentication plugin.

ORA-01017SQL

ORA-01017: invalid username/password; logon denied

Oracle rejected the credentials.

1142MySQL

MySQL ERROR 1142 (42000): SELECT command denied to user 'x'@'host' for table 'y'

The account lacks the privilege for that statement on that table.

1227MySQL

MySQL ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

The import or statement needs SUPER/SYSTEM_VARIABLES_ADMIN — typical with dumps containing DEFINER clauses or SET GLOBAL on manag…

2003MySQL

MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111)

The client couldn’t reach MySQL over TCP — server down, wrong host/port, firewall, or MySQL bound to localhost only.

245SQL

SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245)

SQL Server tried to convert text to a number (often implicitly) and hit a non-numeric value.

8115SQL

SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)

A value or calculation exceeds the target data type’s range.

544SQL

SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF.

An INSERT supplied a value for an IDENTITY column.

1146MySQL

MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist

The query references a table that MySQL can’t find in that database.

42703PostgreSQL

PostgreSQL: ERROR: column "x" does not exist

PostgreSQL can’t find the column — a missing migration, a case-sensitive quoted name, or a string literal written in double quote…

1051MySQL

MySQL ERROR 1051 (42S02): Unknown table 'x'

DROP TABLE targeted a table that doesn’t exist.

CERTIFICATE_VERIFY_FAILEDAPI

SSL: CERTIFICATE_VERIFY_FAILED / unable to get local issuer certificate

The client couldn’t verify the server’s TLS certificate chain, so it refused the HTTPS connection.

3D000PostgreSQL

FATAL: database "x" does not exist

The connection names a database that isn’t on that server.

53300PostgreSQL

FATAL: sorry, too many clients already / remaining connection slots are reserved for non-replication superuser connections

PostgreSQL reached max_connections.

EACCESLinux

Linux: Permission denied

Your user (or the service user) lacks read/write/execute permission on a file, directory or one of its parents.

create extension deniedPostgreSQL

ERROR: permission denied to create extension "x" — Must be superuser to create this extension.

Your role lacks the privilege to create that extension.