MySQL common error code: MySQL error number

1016 error: the file cannot be opened. Use the background or phpmyadmin to fix the problem.
1044 error: the database user permissions are insufficient. Contact the Space Provider to solve the problem.
1045 error: Incorrect database server/database username/database name/Database Password. Please contact the Space Provider to check your account.
1054 error: the program file conflicts with the database. Use the correct program file to upload and overwrite it.
1146 error: the data table is missing. Please restore the backup data.
2002 error: the server port is incorrect. Contact the space provider for the correct port.
2003 error: mysql service is not started. Please start this service
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

Note: The above is only a common error code, and the solution may not always work! For more information, see the MYSQL manual)

More detailed error codes

Error name/error code SQL status
ER_HASHCHK 1000
HY000
Er_nisamchk 1001 hy000
Er_no
1002 hy000
Er_yes 1003
Hy000
Er_cant_createe_file 1004 hy000
Er_cant_create_table
1005 hy000
Er_cant_create_db 1006
Hy000
Er_db_create_exists 1007 hy000
Er_db_drop_exists
1008 hy000
Er_db_drop_delete 1009
Hy000
Er_db_drop_rmdir 1010 hy000
Er_cant_deletee_file 1011
Hy000
Er_cant_find_system_rec 1012 hy000
Er_cant_get_stat 1013
Hy000
Er_cant_get_wd 1014 hy000
Er_cant_lock 1015.
Hy000
Er_cant_open_file 1016 hy000
Er_file_not_found 1017
Hy000
Er_cant_read_dir 1018 hy000
ER_CANT_SET_WD 1019
HY000
ER_CHECKREAD 1020 HY000
ER_DISK_FULL 1021 HY000
ER_DUP_KEY 1022.
23000
ER_ERROR_ON_CLOSE 1023 HY000
ER_ERROR_ON_READ 1024
HY000
ER_ERROR_ON_RENAME 1025 HY000
ER_ERROR_ON_WRITE 1026
HY000
ER_FILE_USED 1027 HY000
ER_FILSORT_ABORT 1028
HY000
ER_FORM_NOT_FOUND 1029 HY000
Er_get_errno. 1030
HY000
Er_illegall_ha 1031 HY000
ER_KEY_NOT_FOUND 1032
HY000
ER_NOT_FORM_FILE 1033 HY000
ER_NOT_KEYFILE 1034
HY000
ER_OLD_KEYFILE 1035 HY000
ER_OPEN_AS_READONLY 1036
HY000
ER_OUTOFMEMORY 1037 HY001
ER_OUT_OF_SORTMEMORY 1038
HY001
ER_UNEXPECTED_EOF 1039 HY000
ER_CON_COUNT_ERROR 1040.
08004
ER_OUT_OF_RESOURCES 1041 08004
ER_BAD_HOST_ERROR 1042
08S01
ER_HANDSHAKE_ERROR 1043 08S01
ER_DBACCESS_DENIED_ERROR 1044
42000
ER_ACCESS_DENIED_ERROR 1045 42000
ER_NO_DB_ERROR 1046.
42000
ER_UNKNOWN_COM_ERROR 1047 08S01
ER_BAD_NULL_ERROR 1048.
23000
ER_BAD_DB_ERROR 1049 42000
ER_TABLE_EXISTS_ERROR 1050.
42S01
ER_BAD_TABLE_ERROR 1051 42S02
ER_NON_UNIQ_ERROR 1052
23000
Er_server_shut down 1053 08S01
ER_BAD_FIELD_ERROR 1054.
42S22
ER_WRONG_FIELD_WITH_GROUP 1055 42000
ER_WRONG_GROUP_FIELD 1056
42000
ER_WRONG_SUM_SELECT 1057 42000
ER_WRONG_VALUE_COUNT 1058
21S01
Er_too_long_id 1059 42000
ER_DUP_FIELDNAME 1060
42S21
Er_dup_key name 1061 42000
ER_DUP_ENTRY 1062.
23000
ER_WRONG_FIELD_SPEC 1063 42000
ER_PARSE_ERROR 1064
42000
ER_EMPTY_QUERY 1065 42000
ER_NONUNIQ_TABLE 1066
42000
ER_INVALID_DEFAULT 1067 42000
ER_MULTIPLE_PRI_KEY 1068
42000
ER_TOO_MANY_KEYS 1069 42000
ER_TOO_MANY_KEY_PARTS 1070
42000
ER_TOO_LONG_KEY 1071 42000
ER_KEY_COLUMN_DOES_NOT_EXITS 1072
42000
Er_blob_used_as_key 1073 42000
Er_too_big_fieldlength 1074
42000
Er_wrong_auto_key 1075 42000
Er_ready 1076
00000
Er_normal_shut down 1077 00000
Er_got_signal 1078
00000
Er_shutdown_complete 1079 00000
Er_forcing_close 1080
08s01
Er_ipsock_error 1081 08s01
Er_no_such_index 1082
42s12
Er_wrong_field_terminatators 1083 42000
Er_blobs_and_no_terminated
1084 42000
Er_textfile_not_readable 1085 hy000
Er_file_exists_error 1086.
Hy000
Er_load_info 1087 hy000
Er_alter_info 1088 hy000
Er_wrong_sub_key
1089 hy000
ER_CANT_REMOVE_ALL_FIELDS 1090 42000
ER_CANT_DROP_FIELD_OR_KEY
1091 42000
ER_INSERT_INFO 1092 HY000
ER_UPDATE_TABLE_USED 1093
HY000
ER_NO_SUCH_THREAD 1094 HY000
ER_KILL_DENIED_ERROR 1095
HY000
ER_NO_TABLES_USED 1096 HY000
ER_TOO_BIG_SET 1097
HY000
Er_no_unique_log file 1098 HY000
ER_TABLE_NOT_LOCKED_FOR_WRITE 1099
HY000
ER_TABLE_NOT_LOCKED 1100 HY000
Er_blob_cant_have_defaults 1101
42000
ER_WRONG_DB_NAME 1102 42000
ER_WRONG_TABLE_NAME 1103
42000
ER_TOO_BIG_SELECT 1104 42000
ER_UNKNOWN_ERROR 1105
HY000
ER_UNKNOWN_PROCEDURE 1106 42000
ER_WRONG_PARAMCOUNT_TO_PROCEDURE
1107 42000
ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 HY000
ER_UNKNOWN_TABLE
1109 42s02's
ER_FIELD_SPECIFIED_TWICE 1110 42000
ER_INVALID_GROUP_FUNC_USE
1111 42000
Er_unsupported_extension1112 42000
ER_TABLE_MUST_HAVE_COLUMNS
1113 42000
ER_RECORD_FILE_FULL 1114 HY000
ER_UNKNOWN_CHARACTER_SET 1115
42000
ER_TOO_MANY_TABLES 1116 HY000
ER_TOO_MANY_FIELDS 1117
HY000
ER_TOO_BIG_ROWSIZE 1118 42000
ER_STACK_OVERRUN 1119
HY000
ER_WRONG_OUTER_JOIN 1120 42000
ER_NULL_COLUMN_IN_INDEX 1121
42000
Er_cant_find_udfs 1122 HY000
Er_cant_initialize_udfs 1123
Hy000
Er_udf_no_paths 1124 hy000
Er_udf_exists 1125.
Hy000
Er_cant_open_library 1126 hy000
Er_cant_find_dl_entry 1127
Hy000
Er_function_not_defined 1128 hy000
Er_host_is_block ed 1129
Hy000
Er_host_not_privileged 1130 hy000
Er_password_anonymous_user 1131
42000
Er_password_not_allowed 1132 42000
Er_password_no_match 1133
42000
Er_update_info 1134 hy000
Er_cant_create_thread 1135
Hy000
Er_wrong_value_count_on_row 1136 21s01
Er_cant_reopen_table 1137
Hy000
Er_invalid_use_of_null 1138 42000
Er_regexp_error 1139.
42000
Er_mix_of_group_func_and_fields 1140 42000
Er_nonexisting_grant 1141.
42000
Er_tableaccess_denied_error 1142 42000
Er_columnaccess_denied_error
1143 42000
Er_illegal_grant_for_table 1144
42000
Er_grant_wrong_host_or_user 1145 42000
Er_no_such_table 1146
42s02
Er_nonexisting_table_grant 1147 42000
Er_not_allowed_command 1148
42000
Er_syntax_error 1149 42000
Er_delayed_cant_change_lock 1150.
Hy000
Er_too_many_delayed_threads 1151 hy000
Er_aborting_connection 1152
08s01
Er_net_packet_too_large 1153 08s01
Er_net_read_error_from_pipeline 1154
08s01
Er_net_fcntl_error 1155 08s01
ER_NET_PACKETS_OUT_OF_ORDER 1156
08S01
ER_NET_UNCOMPRESS_ERROR 1157 08S01
ER_NET_READ_ERROR 1158
08S01
ER_NET_READ_INTERRUPTED 1159 08S01
ER_NET_ERROR_ON_WRITE 1160
08S01
ER_NET_WRITE_INTERRUPTED 1161 08S01
ER_TOO_LONG_STRING 1162
42000
ER_TABLE_CANT_HANDLE_BLOB 1163
42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164
42000
ER_DELAYED_INSERT_TABLE_LOCKED 1165 HY000
ER_WRONG_COLUMN_NAME 1166
42000
Er_wrong_key_colum1167 42000
ER_WRONG_MRG_TABLE 1168
HY000
ER_DUP_UNIQUE 1169 23000
ER_BLOB_KEY_WITHOUT_LENGTH 1170
42000
ER_PRIMARY_CANT_HAVE_NULL 1171 42000
ER_TOO_MANY_ROWS 1172
42000
Er_requires_primary_keys 1173 42000
Er_no_raid _ compiled 1174
HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 HY000
ER_KEY_DOES_NOT_EXITS
1176 HY000
ER_CHECK_NO_SUCH_TABLE 1177 42000
ER_CHECK_NOT_IMPLEMENTED 1178
42000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179
25000
ER_ERROR_DURING_COMMIT 1180 HY000
ER_ERROR_DURING_ROLLBACK 1181
HY000
ER_ERROR_DURING_FLUSH_LOGS 1182 HY000
ER_ERROR_DURING_CHECKPOINT
1183 HY000
ER_NEW_ABORTING_CONNECTION 1184 08S01
ER_DUMP_NOT_IMPLEMENTED
1185 HY000
ER_FLUSH_MASTER_BINLOG_CLOSED 1186 HY000
ER_INDEX_REBUILD 1187
HY000
ER_MASTER 1188 HY000
ER_MASTER_NET_READ 1189
08S01
ER_MASTER_NET_WRITE 1190 08S01
ER_FT_MATCHING_KEY_NOT_FOUND 1191
HY000
ER_LOCK_OR_ACTIVE_TRANSACTION 1192 HY000
ER_UNKNOWN_SYSTEM_VARIABLE
1193 HY000
ER_CRASHED_ON_USAGE 1194 HY000
ER_CRASHED_ON_REPAIR 1195
HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 HY000
Er_trans_cache_full-time 1197
HY000
ER_SLAVE_MUST_STOP 1198 HY000
ER_SLAVE_NOT_RUNNING 1199
HY000
ER_BAD_SLAVE 1200 HY000
ER_MASTER_INFO 1201 HY000
ER_SLAVE_THREAD
1202 HY000
ER_TOO_MANY_USER_CONNECTIONS 1203 42000
ER_SET_CONSTANTS_ONLY
1204 hy000
Er_lock_wait_time out 1205 hy000
Er_lock_table_full 1206
Hy000
Er_read_only_transactions 1207 25000
Er_drop_db_with_read_lock 1208
Hy000
Er_create_db_with_read_lock 1209 hy000
Er_wrong_arguments 1210
Hy000
Er_no_permission_to_create_user 1211
42000
Er_union_table_in_different_dir 1212 hy000
Er_lock_deadlock 1213
40001
Er_table_cant_handle_fulltext 1214 hy000
Er_cannot_add_foreign 1215
Hy000
Er_no_reference_row 1216 23000
Er_row_is_referenced 1217
23000
Er_connect_to_master 1218 08s01
Er_query_on_master 1219
Hy000
ER_ERROR_WHEN_EXECUTING_COMMAND 1220 HY000
ER_WRONG_USAGE 1221
HY000
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222
21000
ER_CANT_UPDATE_WITH_READLOCK 1223 HY000
ER_MIXING_NOT_ALLOWED 1224
HY000
ER_DUP_ARGUMENT 1225 HY000
ER_USER_LIMIT_REACHED 1226
42000
ER_SPECIFIC_ACCESS_DENIED_ERROR 1227 HY000
ER_LOCAL_VARIABLE 1228
HY000
ER_GLOBAL_VARIABLE 1229 HY000
ER_NO_DEFAULT 1230
42000
ER_WRONG_VALUE_FOR_VAR 1231 42000
ER_WRONG_TYPE_FOR_VAR 1232
42000
ER_VAR_CANT_BE_READ 1233 HY000
ER_CANT_USE_OPTION_HERE 1234
42000
ER_NOT_SUPPORTED_YET 1235 42000
ER_MASTER_FATAL_ERROR_READING_BINLOG
1236 HY000
Er_wirong_fk_def 1237 42000
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF
1238 HY000
ER_CARDINALITY_COL 1239 21000
ER_SUBSELECT_NO_1_ROW 1240
21000
ER_UNKNOWN_STMT_HANDLER 1241 HY000
ER_CORRUPT_HELP_DB 1242
HY000
Er_policic_reference 1243 HY000
Er_auto_converter 1244
HY000
ER_ILLEGAL_REFERENCE 1245 42S22
ER_DERIVED_MUST_HAVE_ALIAS 1246
42000
Er_select_ced CED 1247 01000
ER_TABLENAME_NOT_ALLOWED_HERE 1248
42000
ER_NOT_SUPPORTED_AUTH_MODE 1249 08004
ER_SPATIAL_CANT_HAVE_NULL 1250.
42000
ER_COLLATION_CHARSET_MISMATCH 1251 42000
ER_SLAVE_WAS_RUNNING 1252
HY000
ER_SLAVE_WAS_NOT_RUNNING 1253 HY000
ER_TOO_BIG_FOR_UNCOMPRESS 1254
HY000
ER_ZLIB_Z_MEM_ERROR 1255 HY000
ER_ZLIB_Z_BUF_ERROR 1256.
HY000
ER_ZLIB_Z_DATA_ERROR 1257 HY000
ER_CUT_VALUE_GROUP_CONCAT 1258
HY000
ER_WARN_TOO_FEW_RECORDS 1259 01000
ER_WARN_TOO_MANY_RECORDS 1260
01000
ER_WARN_NULL_TO_NOTNULL 1261 01000
ER_WARN_DATA_OUT_OF_RANGE 1262
01000
ER_WARN_DATA_TRUNCATED 1263 01000
Er_warn_using_other_handller 1264
01000
Er_cant_aggregateway e_collations 1265 42000
ER_DROP_USER 1266
42000
ER_REVOKE_GRANTS 1267 42000