Error map

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

MySQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (8). 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.

1044 — MySQL ERROR 1044 (42000): Access denied for user to database (MySQL)10441045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)10451227 — MySQL ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation (MySQL)12271130 — MySQL ERROR 1130 (HY000): Host 'x' is not allowed to connect to this MySQL server (MySQL)11301418 — MySQL ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (MySQL)1418create extension denied — ERROR: permission denied to create extension "x" — Must be superuser to create this extension. (PostgreSQL)create extension de…1146 — MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist (MySQL)114642501 — PostgreSQL: ERROR: permission denied for table / schema public (PostgreSQL)425011142 — MySQL ERROR 1142 (42000): SELECT command denied to user 'x'@'host' for table 'y' (MySQL)11422002 — 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)200628P01 — PostgreSQL: FATAL: password authentication failed for user (PostgreSQL)28P01not a constructor — TypeError: x is not a constructor (JavaScript)not a constructorTDZ — ReferenceError: Cannot access 'x' before initialization (JavaScript)TDZ1046 — MySQL ERROR 1046 (3D000): No database selected (MySQL)10461698 — MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost' (MySQL)16982003 — MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111) (MySQL)2003caching_sha2_password — Authentication plugin 'caching_sha2_password' cannot be loaded (MySQL)caching_sha2_passwo…1040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)10401005 — MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed") (MySQL)10051007 — MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists (MySQL)1007intl missing — Class "NumberFormatter" not found / The "intl" PHP extension is required (PHP)intl missing42883 function — ERROR: function x(text) does not exist — No function matches the given name and argument types (PostgreSQL)42883 functionextension not available — ERROR: could not open extension control file ".../postgis.control": No such file or directory (PostgreSQL)extension not avail…1064 — MySQL ERROR 1064 (42000): You have an error in your SQL syntax (MySQL)10641054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)10541452 — MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)1452EACCES — Linux: Permission denied (Linux)EACCES

Directly related (8)

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.

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…

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.

1418MySQL

MySQL ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

Creating a stored function failed because binary logging requires it to declare its data access characteristics.

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.

1146MySQL

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

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

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…

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.

Two steps away (19)

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`.

28P01PostgreSQL

PostgreSQL: FATAL: password authentication failed for user

PostgreSQL rejected the password for that role, or pg_hba.conf requires a different auth method.

not a constructorJavaScript

TypeError: x is not a constructor

new was used with something that isn’t a class/constructor — usually a wrong import.

TDZJavaScript

ReferenceError: Cannot access 'x' before initialization

A let/const/class was used before its declaration line ran (temporal dead zone) — often a circular import.

1046MySQL

MySQL ERROR 1046 (3D000): No database selected

A query referenced tables without a database selected (no USE and no db in the connection).

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.

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.

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.

1040MySQL

MySQL ERROR 1040 (08004): Too many connections

MySQL reached `max_connections` and refuses new clients.

1005MySQL

MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed")

A foreign key definition is invalid — the referenced column’s type, index or charset doesn’t match.

1007MySQL

MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists

CREATE DATABASE ran for a database that already exists.

intl missingPHP

Class "NumberFormatter" not found / The "intl" PHP extension is required

Code uses the intl extension (NumberFormatter, Collator, IntlDateFormatter) but it isn’t installed.

42883 functionPostgreSQL

ERROR: function x(text) does not exist — No function matches the given name and argument types

PostgreSQL found no function with that name and argument types — wrong types, missing extension, or schema not in search_path.

extension not availablePostgreSQL

ERROR: could not open extension control file ".../postgis.control": No such file or directory

CREATE EXTENSION failed because the extension’s files aren’t installed on the server.

1064MySQL

MySQL ERROR 1064 (42000): You have an error in your SQL syntax

MySQL couldn’t parse the query. The text after “near” shows where parsing failed.

1054MySQL

MySQL ERROR 1054 (42S22): Unknown column in 'field list'

The query references a column that doesn’t exist in the table (or an unquoted string being read as a column).

1452MySQL

MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

You inserted/updated a row whose foreign key value doesn’t exist in the referenced parent table.

EACCESLinux

Linux: Permission denied

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