Skip to content

All MySQL errors

Every error in the library, by number and alphabetically. 27 errors so far.

By error number

  1. 1040 Too many connections
  2. 1045 Access denied for user (using password: YES or NO)
  3. 1046 No database selected
  4. 1048 Column cannot be null
  5. 1049 Unknown database
  6. 1054 Unknown column
  7. 1055 Expression is not in GROUP BY (ONLY_FULL_GROUP_BY)
  8. 1062 Duplicate entry for key
  9. 1064 You have an error in your SQL syntax
  10. 1130 Host is not allowed to connect to this MySQL server
  11. 1136 Column count doesn't match value count
  12. 1142 Command denied to user for table
  13. 1146 Table doesn't exist
  14. 1153 Got a packet bigger than 'max_allowed_packet' bytes
  15. 1205 Lock wait timeout exceeded; try restarting transaction
  16. 1213 Deadlock found when trying to get lock
  17. 1264 Out of range value for column
  18. 1292 Incorrect date or datetime value
  19. 1364 Field doesn't have a default value
  20. 1366 Incorrect integer, decimal or string value for column
  21. 1406 Data too long for column
  22. 1451 Cannot delete or update a parent row: a foreign key constraint fails
  23. 1452 Cannot add or update a child row: a foreign key constraint fails
  24. 2002 Can't connect to local MySQL server through socket
  25. 2003 Can't connect to MySQL server on host:port
  26. 2006 MySQL server has gone away
  27. 2013 Lost connection to MySQL server during query

A to Z by message

A

C

D

E

F

G

H

I

L

M

N

O

T

U

Y