MySQL error code description list explains a table that goes through mysql errors. in the past, I often used to guess. with this table, I checked it and found it. this is convenient for many users.
1005: An error occurred while creating the table.
1006: database creation failed
1007: The database already exists. An error occurred while creating the database.
1008: The database does not exist. An error occurred while deleting the database.
1009: the database file cannot be deleted, leading to database deletion failure.
1010: failed to delete database because the data directory cannot be deleted
1011: An error occurred while deleting the database file.
1012: records in the system table cannot be read.
1020: The record has been modified by another user
1021: the remaining space on the hard disk is insufficient. Please increase the available space on the hard disk.
1022: duplicate keywords. failed to change the record
1023: An error occurred while disabling the service.
1024: An error occurred while reading the file.
1025: An error occurred while changing the name
1026: File write error
1032: The record does not exist
1036: the data table is read-only and cannot be modified.
1037: the system memory is insufficient. restart the database or restart the server.
1038: the memory used for sorting is insufficient. increase the sorting buffer.
1040: maximum number of connections to the database. increase the number of available connections to the database.
1041: insufficient system memory
1042: invalid host name
1043: invalid connection
1044: the current user is not authorized to access the database
1045: The database cannot be connected. the user name or password is incorrect.
1048: the field cannot be blank
1049: The database does not exist.
1050: the data table already exists.
1051: the data table does not exist.
1054: the field does not exist.
1065: invalid SQL statement. The SQL statement is empty.
1081: cannot establish Socket connection
1114: the data table is full and cannot accommodate any Records
1116: too many open data tables
1129: database exception. restart the database.
1130: failed to connect to the database. you are not authorized to connect to the database.
1133: The database user does not exist
1141: the current user is not authorized to access the database
1142: the current user is not authorized to access the data table
1143: the current user is not authorized to access fields in the data table.
1146: the data table does not exist.
1147: the user's access permission to the data table is not defined.
1149: SQL statement syntax error
1158: Network Error. read error. check the network connection status.
1159: Network Error. Read Timeout. check the network connection status.
1160: Network Error. a write error occurs. check the network connection status.
1161: Network Error. write timeout. check the network connection status.
1062: The field value is repeated and the database import fails.
1169: The field value is repeated and the update record fails.
1177: An error occurred while opening the data table.
1180: transaction submission failed
1181: transaction rollback failed
1203: the maximum number of connections established between the current user and the database to reach the database. increase the number of available database connections or restart the database.
1205: Lock Timeout
1211: the current user does not have the permission to create a user
1216: failed to check foreign key constraints and failed to update sub-table records
1217: failed to check foreign key constraints, failed to delete or modify the primary table record
1226: the resource used by the current user has exceeded the allowed Resource. please restart the database or the server.
1227: You are not authorized to perform this operation.
1235: MySQL version is too low and does not have this function