🐬 MySQL errors

MySQL and MariaDB error codes like 1045, 1064, 1146 and 2002.

CodeErrorWhat it means
1045 MySQL ERROR 1045 (28000): Access denied for user MySQL rejected the login — wrong password, wrong user/host combination, or the user doesn’t exist.
1044 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.
1054 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).
1062 MySQL ERROR 1062 (23000): Duplicate entry for key An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.
1064 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.
1146 MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist The query references a table that MySQL can’t find in that database.
1452 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.
2002 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 i…
2006 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`.