MySQL Error Codes

MySQL Error Codes: Complete reference of MySQL 8.0 server error codes (numeric codes like… Searchable index with fixes, code examples, and official sources.

MySQL reports errors with a numeric code plus a SQLSTATE. The code tells you which subsystem failed — 1xxx codes cover connection and authentication, 10xx–11xx cover SQL parsing and schema lookups, 12xx cover locking and transactions, and 13xx–14xx cover constraint enforcement on writes. Each page below pairs the official message with the concrete statement that triggers it and a fix you can paste into a migration or a retry loop.

12 error codes MySQL Last verified 2026-08-19

All 12 error codes

1062 Duplicate Entry Duplicate entry '%s' for key %s 1064 SQL Syntax Error %s near '%s' at line %s 1045 Access Denied for User Access denied for user '%s'@'%s' (using password: %s) 1146 Table Doesn't Exist Table '%s.%s' doesn't exist 1451 Foreign Key Constraint Fails on Delete or Update Cannot delete or update a parent row: a foreign key constraint fails (%s) 1452 Foreign Key Constraint Fails on Insert Cannot add or update a child row: a foreign key constraint fails (%s) 1048 Column Cannot Be Null Column '%s' cannot be null 1054 Unknown Column Unknown column '%s' in '%s' 1215 Cannot Add Foreign Key Constraint Cannot add foreign key constraint 1205 Lock Wait Timeout Exceeded Lock wait timeout exceeded; try restarting transaction 1213 Deadlock Found When Trying to Get Lock Deadlock found when trying to get lock; try restarting transaction 1364 Field Doesn't Have a Default Value Field '%s' doesn't have a default value

Official Sources