MySQL common error code: MySQL error number

Source: Internet
Author: User
Tags mysql manual
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.