MySQL error number (Common MySQL error code)

Address: http://hi.baidu.com/leilei1334/blog/item/2dcfe8ce93df890092457e3d.html

 

The error is that two MySQL instances installed on the MySQL error number 2003 Machine

One is mysql5.0 port: 3305 Manual start service

One is mysql6.0 port: 3306 Manual start service

The logon status when using MySQL administrator is

Mysql5.0 started, mysql6.0 not started

This error occurs during logon because port 3306 is used to log on to mysql6.0.

The following is a related article. Based on his prompt, he found the cause of the error.

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.
2003Error:MySQLThe service is not started. Please start the 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:MySQLThe 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, seeMySQLManual (download from all major download sites)

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_create_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_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_illegal_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_shutdown? 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_ident? 1059? 42000
Er_dup_fieldname? 1060? 42s21
Er_dup_keyname? 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_shutdown? 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_terminators? 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_logfile? 1098? Hy000
Er_table_not_locked_for_write? 1099? Hy000
Er_table_not_locked? 1100? Hy000
Er_blob_cant_have_default? 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_use? 1111? 42000
Er_unsupported_extension? 1112? 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_udf? 1122? Hy000
Er_cant_initialize_udf? 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_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_column? 1167? 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_key? 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? 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_timeout? 1205? Hy000
Er_lock_table_full? 1206? Hy000
Er_read_only_transaction? 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_tables_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_referenced_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_wrong_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_aggregate_collations? 1265? 42000
Er_drop_user? 1266? 42000
Er_revoke_grants? 1267? 42000