mysql1032错误

傷城~ 2023-09-25 10:41 72阅读 0赞

## 刚刚安装好了mysql 跟mysql\_front但是创建的时候出现1007错误！怎么回事！！急！！谢谢 ##

MySQL中1007错误一般是创建同名数据库导致的；

![mysql1032错误\_mysql1032][mysql1032_mysql1032]

## mysql错误号1045 ##

修改config.php以适合你的数据库

MYSQL常见出错代码！

1016错误：文件无法打开，使用后台修复或者使用phpmyadmin进行修复。

1044错误：数据库用户权限不足，请联系空间商解决

1045错误：数据库服务器/数据库用户名/数据库名/数据库密码错误，请联系空间商检查帐户。

1054错误：程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖。

1146错误：数据表缺失,请恢复备份数据.

1005：创建表失败

1006：创建数据库失败

1007：数据库已存在，创建数据库失败

1008：数据库不存在，删除数据库失败

1009：不能删除数据库文件导致删除数据库失败

1010：不能删除数据目录导致删除数据库失败

1011：删除数据库文件失败

1012：不能读取系统表中的记录

1020：记录已被其他用户修改

1021：硬盘剩余空间不足，请加大硬盘可用空间

1022：关键字重复，更改记录失败

1023：关闭时发生错误

1024：读文件错误

1025：更改名字时发生错误

1026：写文件错误

1032：记录不存在

1036：数据表是只读的，不能对它进行修改

1037：系统内存不足，请重启数据库或重启服务器

1038：用于排序的内存不足，请增大排序缓冲区

1040：已到达数据库的最大连接数，请加大数据库可用连接数

1041：系统内存不足

1042：无效的主机名

1043：无效连接

1044：当前用户没有访问数据库的权限

1045：不能连接数据库，用户名或密码错误

1048：字段不能为空

1049：数据库不存在

1050：数据表已存在

1051：数据表不存在

1054：字段不存在

1065：无效的SQL语句，SQL语句为空

1081：不能建立Socket连接

1114：数据表已满，不能容纳任何记录

1116：打开的数据表太多

1129：数据库出现异常，请重启数据库

1130：连接数据库失败，没有连接数据库的权限

1133：数据库用户不存在

1141：当前用户无权访问数据库

1142：当前用户无权访问数据表

1143：当前用户无权访问数据表中的字段

1146：数据表不存在

1147：未定义用户对数据表的访问权限

1149：SQL语句语法错误

1158：网络错误，出现读错误，请检查网络连接状况

1159：网络错误，读超时，请检查网络连接状况

1160：网络错误，出现写错误，请检查网络连接状况

1161：网络错误，写超时，请检查网络连接状况

1062：字段值重复，入库失败

1169：字段值重复，更新记录失败

1177：打开数据表失败

1180：提交事务失败

1181：回滚事务失败

1203：当前用户和数据库建立的连接已到达数据库的最大连接数，请增大可用的数据库连接数或重启数据库

1205：加锁超时

1211：当前用户没有创建用户的权限

1216：外键约束检查失败，更新子表记录失败

1217：外键约束检查失败，删除或修改主表记录失败

1226：当前用户使用的资源已超过所允许的资源，请重启数据库或重启服务器

1227：权限不足，您无权进行此操作

1235：MySQL版本过低，不具有本功能

2002：Can'tconnectto...通常意味着没有一个MySQL服务器运行在系统上或当试图连接mysqld服务器时，你正在使用一个错误的套接字文件或TCP/IP端口。

说明：以上只是常见错误号，并且解决办法也不一定肯定管用！具体请参考MYSQL手册(各大下载站均有下载)

更多详细错误代码

错误名称/错误代码SQL状态

ER\_HASHCHK1000HY000

ER\_NISAMCHK1001HY000

ER\_NO1002HY000

ER\_YES1003HY000

ER\_CANT\_CREATE\_FILE1004HY000

ER\_CANT\_CREATE\_TABLE1005HY000

ER\_CANT\_CREATE\_DB1006HY000

ER\_DB\_CREATE\_EXISTS1007HY000

ER\_DB\_DROP\_EXISTS1008HY000

ER\_DB\_DROP\_DELETE1009HY000

ER\_DB\_DROP\_RMDIR1010HY000

ER\_CANT\_DELETE\_FILE1011HY000

ER\_CANT\_FIND\_SYSTEM\_REC1012HY000

ER\_CANT\_GET\_STAT1013HY000

ER\_CANT\_GET\_WD1014HY000

ER\_CANT\_LOCK1015HY000

ER\_CANT\_OPEN\_FILE1016HY000

ER\_FILE\_NOT\_FOUND1017HY000

ER\_CANT\_READ\_DIR1018HY000

ER\_CANT\_SET\_WD1019HY000

ER\_CHECKREAD1020HY000

ER\_DISK\_FULL1021HY000

ER\_DUP\_KEY102223000

ER\_ERROR\_ON\_CLOSE1023HY000

ER\_ERROR\_ON\_READ1024HY000

ER\_ERROR\_ON\_RENAME1025HY000

ER\_ERROR\_ON\_WRITE1026HY000

ER\_FILE\_USED1027HY000

ER\_FILSORT\_ABORT1028HY000

ER\_FORM\_NOT\_FOUND1029HY000

ER\_GET\_ERRNO1030HY000

ER\_ILLEGAL\_HA1031HY000

ER\_KEY\_NOT\_FOUND1032HY000

ER\_NOT\_FORM\_FILE1033HY000

ER\_NOT\_KEYFILE1034HY000

ER\_OLD\_KEYFILE1035HY000

ER\_OPEN\_AS\_READONLY1036HY000

ER\_OUTOFMEMORY1037HY001

ER\_OUT\_OF\_SORTMEMORY1038HY001

ER\_UNEXPECTED\_EOF1039HY000

ER\_CON\_COUNT\_ERROR104008004

ER\_OUT\_OF\_RESOURCES104108004

ER\_BAD\_HOST\_ERROR104208S01

ER\_HANDSHAKE\_ERROR104308S01

ER\_DBACCESS\_DENIED\_ERROR104442000

ER\_ACCESS\_DENIED\_ERROR104542000

ER\_NO\_DB\_ERROR104642000

ER\_UNKNOWN\_COM\_ERROR104708S01

ER\_BAD\_NULL\_ERROR104823000

ER\_BAD\_DB\_ERROR104942000

ER\_TABLE\_EXISTS\_ERROR105042S01

ER\_BAD\_TABLE\_ERROR105142S02

ER\_NON\_UNIQ\_ERROR105223000

ER\_SERVER\_SHUTDOWN105308S01

ER\_BAD\_FIELD\_ERROR105442S22

ER\_WRONG\_FIELD\_WITH\_GROUP105542000

ER\_WRONG\_GROUP\_FIELD105642000

ER\_WRONG\_SUM\_SELECT105742000

ER\_WRONG\_VALUE\_COUNT105821S01

ER\_TOO\_LONG\_IDENT105942000

ER\_DUP\_FIELDNAME106042S21

ER\_DUP\_KEYNAME106142000

ER\_DUP\_ENTRY106223000

ER\_WRONG\_FIELD\_SPEC106342000

ER\_PARSE\_ERROR106442000

ER\_EMPTY\_QUERY106542000

ER\_NONUNIQ\_TABLE106642000

ER\_INVALID\_DEFAULT106742000

ER\_MULTIPLE\_PRI\_KEY106842000

ER\_TOO\_MANY\_KEYS106942000

ER\_TOO\_MANY\_KEY\_PARTS107042000

ER\_TOO\_LONG\_KEY107142000

ER\_KEY\_COLUMN\_DOES\_NOT\_EXITS107242000

ER\_BLOB\_USED\_AS\_KEY107342000

ER\_TOO\_BIG\_FIELDLENGTH107442000

ER\_WRONG\_AUTO\_KEY107542000

ER\_READY107600000

ER\_NORMAL\_SHUTDOWN107700000

ER\_GOT\_SIGNAL107800000

ER\_SHUTDOWN\_COMPLETE107900000

ER\_FORCING\_CLOSE108008S01

ER\_IPSOCK\_ERROR108108S01

ER\_NO\_SUCH\_INDEX108242S12

ER\_WRONG\_FIELD\_TERMINATORS108342000

ER\_BLOBS\_AND\_NO\_TERMINATED108442000

ER\_TEXTFILE\_NOT\_READABLE1085HY000

ER\_FILE\_EXISTS\_ERROR1086HY000

ER\_LOAD\_INFO1087HY000

ER\_ALTER\_INFO1088HY000

ER\_WRONG\_SUB\_KEY1089HY000

ER\_CANT\_REMOVE\_ALL\_FIELDS109042000

ER\_CANT\_DROP\_FIELD\_OR\_KEY109142000

ER\_INSERT\_INFO1092HY000

ER\_UPDATE\_TABLE\_USED1093HY000

ER\_NO\_SUCH\_THREAD1094HY000

ER\_KILL\_DENIED\_ERROR1095HY000

ER\_NO\_TABLES\_USED1096HY000

ER\_TOO\_BIG\_SET1097HY000

ER\_NO\_UNIQUE\_LOGFILE1098HY000

ER\_TABLE\_NOT\_LOCKED\_FOR\_WRITE1099HY000

ER\_TABLE\_NOT\_LOCKED1100HY000

ER\_BLOB\_CANT\_HAVE\_DEFAULT110142000

ER\_WRONG\_DB\_NAME110242000

ER\_WRONG\_TABLE\_NAME110342000

ER\_TOO\_BIG\_SELECT110442000

ER\_UNKNOWN\_ERROR1105HY000

ER\_UNKNOWN\_PROCEDURE110642000

ER\_WRONG\_PARAMCOUNT\_TO\_PROCEDURE110742000

ER\_WRONG\_PARAMETERS\_TO\_PROCEDURE1108HY000

ER\_UNKNOWN\_TABLE110942S02

ER\_FIELD\_SPECIFIED\_TWICE111042000

ER\_INVALID\_GROUP\_FUNC\_USE111142000

ER\_UNSUPPORTED\_EXTENSION111242000

ER\_TABLE\_MUST\_HAVE\_COLUMNS111342000

ER\_RECORD\_FILE\_FULL1114HY000

ER\_UNKNOWN\_CHARACTER\_SET111542000

ER\_TOO\_MANY\_TABLES1116HY000

ER\_TOO\_MANY\_FIELDS1117HY000

ER\_TOO\_BIG\_ROWSIZE111842000

ER\_STACK\_OVERRUN1119HY000

ER\_WRONG\_OUTER\_JOIN112042000

ER\_NULL\_COLUMN\_IN\_INDEX112142000

ER\_CANT\_FIND\_UDF1122HY000

ER\_CANT\_INITIALIZE\_UDF1123HY000

ER\_UDF\_NO\_PATHS1124HY000

ER\_UDF\_EXISTS1125HY000

ER\_CANT\_OPEN\_LIBRARY1126HY000

ER\_CANT\_FIND\_DL\_ENTRY1127HY000

ER\_FUNCTION\_NOT\_DEFINED1128HY000

ER\_HOST\_IS\_BLOCKED1129HY000

ER\_HOST\_NOT\_PRIVILEGED1130HY000

ER\_PASSWORD\_ANONYMOUS\_USER113142000

ER\_PASSWORD\_NOT\_ALLOWED113242000

ER\_PASSWORD\_NO\_MATCH113342000

ER\_UPDATE\_INFO1134HY000

ER\_CANT\_CREATE\_THREAD1135HY000

ER\_WRONG\_VALUE\_COUNT\_ON\_ROW113621S01

ER\_CANT\_REOPEN\_TABLE1137HY000

ER\_INVALID\_USE\_OF\_NULL113842000

ER\_REGEXP\_ERROR113942000

ER\_MIX\_OF\_GROUP\_FUNC\_AND\_FIELDS114042000

ER\_NONEXISTING\_GRANT114142000

ER\_TABLEACCESS\_DENIED\_ERROR114242000

ER\_COLUMNACCESS\_DENIED\_ERROR114342000

ER\_ILLEGAL\_GRANT\_FOR\_TABLE114442000

ER\_GRANT\_WRONG\_HOST\_OR\_USER114542000

ER\_NO\_SUCH\_TABLE114642S02

ER\_NONEXISTING\_TABLE\_GRANT114742000

ER\_NOT\_ALLOWED\_COMMAND114842000

ER\_SYNTAX\_ERROR114942000

ER\_DELAYED\_CANT\_CHANGE\_LOCK1150HY000

ER\_TOO\_MANY\_DELAYED\_THREADS1151HY000

ER\_ABORTING\_CONNECTION115208S01

ER\_NET\_PACKET\_TOO\_LARGE115308S01

ER\_NET\_READ\_ERROR\_FROM\_PIPE115408S01

ER\_NET\_FCNTL\_ERROR115508S01

ER\_NET\_PACKETS\_OUT\_OF\_ORDER115608S01

ER\_NET\_UNCOMPRESS\_ERROR115708S01

ER\_NET\_READ\_ERROR115808S01

ER\_NET\_READ\_INTERRUPTED115908S01

ER\_NET\_ERROR\_ON\_WRITE116008S01

ER\_NET\_WRITE\_INTERRUPTED116108S01

ER\_TOO\_LONG\_STRING116242000

ER\_TABLE\_CANT\_HANDLE\_BLOB116342000

ER\_TABLE\_CANT\_HANDLE\_AUTO\_INCREMENT116442000

ER\_DELAYED\_INSERT\_TABLE\_LOCKED1165HY000

ER\_WRONG\_COLUMN\_NAME116642000

ER\_WRONG\_KEY\_COLUMN116742000

ER\_WRONG\_MRG\_TABLE1168HY000

ER\_DUP\_UNIQUE116923000

ER\_BLOB\_KEY\_WITHOUT\_LENGTH117042000

ER\_PRIMARY\_CANT\_HAVE\_NULL117142000

ER\_TOO\_MANY\_ROWS117242000

ER\_REQUIRES\_PRIMARY\_KEY117342000

ER\_NO\_RAID\_COMPILED1174HY000

ER\_UPDATE\_WITHOUT\_KEY\_IN\_SAFE\_MODE1175HY000

ER\_KEY\_DOES\_NOT\_EXITS1176HY000

ER\_CHECK\_NO\_SUCH\_TABLE117742000

ER\_CHECK\_NOT\_IMPLEMENTED117842000

ER\_CANT\_DO\_THIS\_DURING\_AN\_TRANSACTION117925000

ER\_ERROR\_DURING\_COMMIT1180HY000

ER\_ERROR\_DURING\_ROLLBACK1181HY000

ER\_ERROR\_DURING\_FLUSH\_LOGS1182HY000

ER\_ERROR\_DURING\_CHECKPOINT1183HY000

ER\_NEW\_ABORTING\_CONNECTION118408S01

ER\_DUMP\_NOT\_IMPLEMENTED1185HY000

ER\_FLUSH\_MASTER\_BINLOG\_CLOSED1186HY000

ER\_INDEX\_REBUILD1187HY000

ER\_MASTER1188HY000

ER\_MASTER\_NET\_READ118908S01

ER\_MASTER\_NET\_WRITE119008S01

ER\_FT\_MATCHING\_KEY\_NOT\_FOUND1191HY000

ER\_LOCK\_OR\_ACTIVE\_TRANSACTION1192HY000

ER\_UNKNOWN\_SYSTEM\_VARIABLE1193HY000

ER\_CRASHED\_ON\_USAGE1194HY000

ER\_CRASHED\_ON\_REPAIR1195HY000

ER\_WARNING\_NOT\_COMPLETE\_ROLLBACK1196HY000

ER\_TRANS\_CACHE\_FULL1197HY000

ER\_SLAVE\_MUST\_STOP1198HY000

ER\_SLAVE\_NOT\_RUNNING1199HY000

ER\_BAD\_SLAVE1200HY000

ER\_MASTER\_INFO1201HY000

ER\_SLAVE\_THREAD1202HY000

ER\_TOO\_MANY\_USER\_CONNECTIONS120342000

ER\_SET\_CONSTANTS\_ONLY1204HY000

ER\_LOCK\_WAIT\_TIMEOUT1205HY000

ER\_LOCK\_TABLE\_FULL1206HY000

ER\_READ\_ONLY\_TRANSACTION120725000

ER\_DROP\_DB\_WITH\_READ\_LOCK1208HY000

ER\_CREATE\_DB\_WITH\_READ\_LOCK1209HY000

ER\_WRONG\_ARGUMENTS1210HY000

ER\_NO\_PERMISSION\_TO\_CREATE\_USER121142000

ER\_UNION\_TABLES\_IN\_DIFFERENT\_DIR1212HY000

ER\_LOCK\_DEADLOCK121340001

ER\_TABLE\_CANT\_HANDLE\_FULLTEXT1214HY000

ER\_CANNOT\_ADD\_FOREIGN1215HY000

ER\_NO\_REFERENCED\_ROW121623000

ER\_ROW\_IS\_REFERENCED121723000

ER\_CONNECT\_TO\_MASTER121808S01

ER\_QUERY\_ON\_MASTER1219HY000

ER\_ERROR\_WHEN\_EXECUTING\_COMMAND1220HY000

ER\_WRONG\_USAGE1221HY000

ER\_WRONG\_NUMBER\_OF\_COLUMNS\_IN\_SELECT122221000

ER\_CANT\_UPDATE\_WITH\_READLOCK1223HY000

ER\_MIXING\_NOT\_ALLOWED1224HY000

ER\_DUP\_ARGUMENT1225HY000

ER\_USER\_LIMIT\_REACHED122642000

ER\_SPECIFIC\_ACCESS\_DENIED\_ERROR1227HY000

ER\_LOCAL\_VARIABLE1228HY000

ER\_GLOBAL\_VARIABLE1229HY000

ER\_NO\_DEFAULT123042000

ER\_WRONG\_VALUE\_FOR\_VAR123142000

ER\_WRONG\_TYPE\_FOR\_VAR123242000

ER\_VAR\_CANT\_BE\_READ1233HY000

ER\_CANT\_USE\_OPTION\_HERE123442000

ER\_NOT\_SUPPORTED\_YET123542000

ER\_MASTER\_FATAL\_ERROR\_READING\_BINLOG1236HY000

ER\_WRONG\_FK\_DEF123742000

ER\_KEY\_REF\_DO\_NOT\_MATCH\_TABLE\_REF1238HY000

ER\_CARDINALITY\_COL123921000

ER\_SUBSELECT\_NO\_1\_ROW124021000

ER\_UNKNOWN\_STMT\_HANDLER1241HY000

ER\_CORRUPT\_HELP\_DB1242HY000

ER\_CYCLIC\_REFERENCE1243HY000

ER\_AUTO\_CONVERT1244HY000

ER\_ILLEGAL\_REFERENCE124542S22

ER\_DERIVED\_MUST\_HAVE\_ALIAS124642000

ER\_SELECT\_REDUCED124701000

ER\_TABLENAME\_NOT\_ALLOWED\_HERE124842000

ER\_NOT\_SUPPORTED\_AUTH\_MODE124908004

ER\_SPATIAL\_CANT\_HAVE\_NULL125042000

ER\_COLLATION\_CHARSET\_MISMATCH125142000

ER\_SLAVE\_WAS\_RUNNING1252HY000

ER\_SLAVE\_WAS\_NOT\_RUNNING1253HY000

ER\_TOO\_BIG\_FOR\_UNCOMPRESS1254HY000

ER\_ZLIB\_Z\_MEM\_ERROR1255HY000

ER\_ZLIB\_Z\_BUF\_ERROR1256HY000

ER\_ZLIB\_Z\_DATA\_ERROR1257HY000

ER\_CUT\_VALUE\_GROUP\_CONCAT1258HY000

ER\_WARN\_TOO\_FEW\_RECORDS125901000

ER\_WARN\_TOO\_MANY\_RECORDS126001000

ER\_WARN\_NULL\_TO\_NOTNULL126101000

ER\_WARN\_DATA\_OUT\_OF\_RANGE126201000

ER\_WARN\_DATA\_TRUNCATED126301000

ER\_WARN\_USING\_OTHER\_HANDLER126401000

ER\_CANT\_AGGREGATE\_COLLATIONS126542000

ER\_DROP\_USER126642000

ER\_REVOKE\_GRANTS126742000

## 求助，mysql5.6一直提示error 1032 ##

应该是mysql的一个bug

mysql 同步问题 1032错误

Last\_SQL\_Errno: 1032

Last\_SQL\_Error: Could not execute Update\_rows event on table gexin\_sina.sina\_user; Can't find record in 'sina\_user', Error\_code: 1032;

handler error HA\_ERR\_KEY\_NOT\_FOUND; the event's master log mysql-bin.008222, end\_log\_pos 8114684

Replicate\_Ignore\_Server\_Ids:

Master\_Server\_Id: 1

1 row in set (0.00 sec)

mysql的版本目前是 5.5.13

昨天现网数据库，出现了这个错误。在网上查询了下，这个错误是mysql的bug导致的。你只要找到它所在的位置，把它整个文件夹删除，如果有删除不了的你可以使用360文件粉碎机来粉碎它，处理后再用360安全卫士优化一下系统就可以了。

![mysql1032错误\_mysql1032\_02][mysql1032_mysql1032_02]

## mysql 数据库float,int,bigint,double区别 ##

mysql 数据库float,int,bigint,double区别

单精度浮点数(float)的尾数是用24bit表示的，双精度(double)浮点数的尾数是用53bit表示的，转换成十进制： 2^24 - 1 = 16777215 2^53 - 1 = 9007199254740991 由上可见，IEEE754单精度浮点数的有效数字二进制是24位，按十进制来说int是32位整数

bigint就是long,64为整数

float是单精度的,32位

double是双精度,64位

单价是小数点两位的 推荐用numeric(18,2)

到里看看吧，有很详细的介绍

[mysql1032_mysql1032]: https://img2.baidu.com/it/u=608759638,298633930&fm=26&fmt=auto
[mysql1032_mysql1032_02]: https://img2.baidu.com/it/u=2024604725,4209819854&fm=26&fmt=auto