MySQL error code list

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
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:ProgramFile 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
More error detailsCode
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_delete_file 1011 hy000
Er_cant_find_system_rec 1012 hy000
Er_cant_get_stat1013 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_fielddname 1060 42s21
Er_dup_key name 1061 42000
Er_dup_entry 1062 23000
Er_wrong_field_spec 1063 42000
Er_partse_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
Er_field_specified_twice 1110 42000
Er_invalid_group_func_usage 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_overexecute 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_blocked 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_pipe 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_blobs 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_rorws 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_implemented1178 42000
Er_cant_do_this_during_an_transaction 1179 25000
Er_error_during_commit 1180 hy000
Er_error_during_rollback1181 hy000
Er_error_during_flush_logs 1182 hy000
Er_error_during_checkpoint 1183 hy000
Er_new_aborting_connection 1184 08s01
Er_dump_not_implemented1185 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 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_deadlock1213 40001
Er_table_cant_handle_fulltext 1214 hy000
Er_cannot_add_foreign 1215 hy000
Er_no_reference_row 1216 23000
Er_row_is_referenforced 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_binary log 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_convert 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_handler 1264 01000
Er_cant_aggregateway e_collations 1265 42000
Er_drop_user 1266 42000
Er_revoke_grants 1267 42000