Error map
1142 MySQL ERROR 1142 (42000): SELECT command denied to user 'x'@'host' for table 'y'
MySQL · layer 5, Data
Centre: this error. First ring: errors it is linked with (6). 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.
Directly related (6)
MySQL ERROR 1045 (28000): Access denied for user
MySQL rejected the login — wrong password, wrong user/host combination, or the user doesn’t exist.
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.
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…
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.
ERROR: permission denied to create extension "x" — Must be superuser to create this extension.
Your role lacks the privilege to create that extension.
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…
Two steps away (15)
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.
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`.
PostgreSQL: FATAL: password authentication failed for user
PostgreSQL rejected the password for that role, or pg_hba.conf requires a different auth method.
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.
MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist
The query references a table that MySQL can’t find in that database.
TypeError: x is not a constructor
new was used with something that isn’t a class/constructor — usually a wrong import.
ReferenceError: Cannot access 'x' before initialization
A let/const/class was used before its declaration line ran (temporal dead zone) — often a circular import.
MySQL ERROR 1046 (3D000): No database selected
A query referenced tables without a database selected (no USE and no db in the connection).
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.
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.
Authentication plugin 'caching_sha2_password' cannot be loaded
An old MySQL client/driver can’t use MySQL 8’s default authentication plugin.
Class "NumberFormatter" not found / The "intl" PHP extension is required
Code uses the intl extension (NumberFormatter, Collator, IntlDateFormatter) but it isn’t installed.
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.
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.
Linux: Permission denied
Your user (or the service user) lacks read/write/execute permission on a file, directory or one of its parents.
Map another error
Popular: 4035004000xC000007BTypeErrorCritical error404NullPointerException