MySQL common error prompt and solution _ MySQL

130: The file format is incorrect. (Not very clear about the error) lhemLet8iIEV0k? % G145: the file cannot be opened. R] 7 }! 8; 2I);-P ^ SP1005: table creation failed. W [K_Qk {$} ke1! 91006: An error occurred while creating the database. PO1e. # Gx9bM)] 2.1007: The database already exists. database creation failed. EnXkt-+ 6m0-1008: Data 130: The file format is incorrect. (Not very clear about the error) lhemLet8iI
EV0k? % G
145: the file cannot be opened. R] 7 }! 8; 2
I);-P ^ SP
1005: An error occurred while creating the table. W [K_Qk {$
} ! 9
1006: An error occurred while creating the database. PO1e. # Gx
9b M)] 2.
1007: The database already exists and creation failed. \ En'x =
Kt-+ 6m0-
1008: The database does not exist. An error occurred while deleting the database. : & 04E
D XqRx + vtA
1009: the database file cannot be deleted, leading to database deletion failure. 5> wy _: =] n
"+ U | 1z % $ Q
1010: The data directory cannot be deleted, leading to database deletion failure. . {F! Xmj3
A0 % '% t
1011: failed to delete the database file. JG} TNA
] GRK @ 8 & L
1012: records in the system table cannot be read. 'C $ B) * \ l *
_ = 8) X! L3
1016: the file cannot be opened. use the background fix or phpmyadmin to fix it. & Amp; MP (3i ~ %
Xkq |} q = <\
Quote: pkp3
Start => All Programs => attachment => command prompt Uf} y
Enter the hard drive letter (LY {E4s
Directory of cd mysql wOUK * DL "4
Cd bin tOjIBZg c}
Input myisamchk-f D: usr/local/mysql/data/bbs/PW_members.MYI: g + vt) a4
Ps: D: usr/local/mysql/data/bbs is the path of your forum database & O3: U}
-F is selected based on the actual situation. Generally, you can choose-r) 5QU1IY.
Pay attention to whether your system disk C or the hard disk space for storing the database is sufficient. generally, errors may occur if the disk space is less than 1 GB. $ T6 => $ ^ ZK
Or use the mysqlcheck command to fix the issue. Specific method: Use the command line to enter the mysql/bin directory and execute CE-\ _
Mysqlcheck-o-r phpwind-uroot-p/nul
Phpwind indicates the name of your database, and root indicates your database Username. then, you are prompted to enter the password. Then your database will be repaired. (N @ "o [7 *
YL1-uTAr
1017: The server is shut down illegally, causing damage to the file. T: 2bY (S
LSXCHuU
1020: The record has been modified by another user. A & Utbll.
"5 eQsafG)
1021: the remaining space on the hard disk is insufficient. Please increase the available space on the hard disk. # JG * o2t &
KmPdCMBM (
1022: duplicate keywords. failed to change the record. Bter1_g? #
AoMFZ & _ B
1023: An error occurred while disabling the service. Y U7ue0> _ v
Nc: H.N 0]
1024: An error occurred while reading the file. 3a. A & x'
(} PG ~ ZD
1025: An error occurred while changing the name. 8q1Q @!
V1X % JFV % g
1026: file writing error. } ^ Li %
-SGRW! $ <
1030: The server may be unstable. (The specific reason is not clear) xgD/S '/S
PRn. RC ((
1032: The record does not exist. ! {B6/nP & F
YgV7W | LV
1036: the data table is read-only and cannot be modified. * MdO
["5J7f
1037: the system memory is insufficient. restart the database or restart the server. J ?? Xf
Ds07] #
1038: the memory used for sorting is insufficient. increase the sorting buffer. RDk? 7 ^ 4
\ Hr + 8/'o =
1040: maximum number of connections to the database. increase the number of available connections to the database. > BLMyJ-x
Z_dNy0-Dz
Quote: EgkM \ (pn
In my. ini, modify max_connections = 100 to max_connections = 1000 or greater, and restart mysql qwyY/zz.
R0_Q "vtDt
1041: insufficient system memory. ,: | 3E5> g
> 18EwKx |
1042: invalid host name. + CW & bIuF
Y2 () @ TU2i
1043: invalid connection. Z '!! MP = z8
# G-0AOC
1044: The database user permissions are insufficient. contact the space provider. Abl | cW @
N % 01] $ \
1045: the database server/database username/database name/database password is incorrect. please contact the space provider to check your account. W1) myR
Sp1/. 1
Quote: 7N} y |? J
Method: Make sure that the SQL _config.php user name and password under the Forum data directory are correct. if you forget the database password, you can change the password as follows: _ xQ *, (EQz
If MySQL is running, stop it first. + & Gqjqx
Start MySQL: bin/safe_mysqld -- skip-grant-tables & Z> ID? Nm, B
You can access MySQL without a password. ! M8l
Then U | eQWHoc
> Use mysql n/U0i ~ 6C/
> Update user set password = password ("new_pass") where user = "root ";! 7 ePEGoE
> Flush privileges; hcm * Wof [
C B: % 5S &
1046: no database is selected. Fr W; $ M;
% ^! E' & u7
1048: the field cannot be blank. O) 5 /? % J <
CQL? RZ
1049: The database does not exist. S D9b & Id =
JNZUWes3r
1050: the data table already exists. B6: 1yd0
_ Nk00d;
1051: the data table does not exist. 0ZQ r [
3Ri:] & C
1054: the field does not exist. create a field by yourself. EM0} n. 'W (
Gm [7') ue
1060: This field cannot be inserted because it is repeated. 0 & L =? BkI
OC (eV p2)
1062: repeated field values. failed to import the database Qv ^ Y l /#;
TTX7vA Acq
Quote: iL? HT-L
1. if an error similar to the primary code "65535" is returned, you can view the auto-increment field of the relevant table and change the field value to * YG} X (H
2. check whether the fields with duplicate primary codes exist in the data table. If yes, delete the record % RIX | l
3. back up the database and repair related tables (note: This situation is common, such as the pw_posts table. do not forget to back up the tables when repairing them). hT] X4
1 ~ LSR r
1064: MySQL does not support encoding in error messages. (B0' "] I]
6 lAeb
1065: invalid SQL statement. The SQL statement is empty. NYk, X _@/
: WrY {Q ~ S4
1067: MySQL version 5 does not support null default values. E CrO r
$ O9CK Bk
1081: cannot establish a Socket connection. N9Y3L z
Yj @
1114: the data table is full and cannot accommodate any records. = 'L + \
Vs + = pf (
1115: the character set is not supported in MySQL. ] $> XztDn1
[% "M # Iu R
1116: too many data tables are opened. R06I @ 71 _
IHZJmYz <0
1129: database exception. restart the database. ZhG) YP dl
-| + MmO %
1130: failed to connect to the database. you are not authorized to connect to the database. G_zH yA
* WvFg0i} q
1133: The database user does not exist. J0 \ D, 'C
"Ojxe % 8L!
1135: the memory may be insufficient. please contact the space provider. U? O, up ^ H
LYza7 = (TW
1141: the current user is not authorized to access the database. ? YYU * 6 @ 'B
DCC &: hN
1142: the current user is not authorized to access the data table. P {Syuprlx
Bq] 8, 0
1143: the current user is not authorized to access fields in the data table. T # 33j # h
R Vznd
1146: the data table is missing. please restore the backup data JLtk] blx
F $ <= [C
1147: the user's access permission to the data table is not defined. DIsbA] p
L :*~ Lp
1149: SQL statement syntax error. '\ | TiD35P
OS oN/[2
1158: Network Error. read error. check the network connection status. 3 p 6E (CRl:
Vt {S3_iPD
1159: Network Error. Read Timeout. check the network connection status. 'Lrht (G u>
H1} \ h, k
1160: Network Error. a write error occurs. check the network connection status. 7% % B ~ X3 |
QOT @ 8 '? _
1161: Network Error. write timeout. check the network connection status. # 0FDK4y
G_ernhX)
1169: The field value is repeated and the update record fails. FIvd
] K2bfN) 7
1177: failed to open the data table. ) X6-20T
V) <sA
1180: transaction submission failed. $0:} Hn % Lz,
_ Gq; 6zOn
1181: failed to roll back the transaction. VTbfbxM
: T ^ 'zarj
1193: set names is not supported ). WR:/8N6
C ["j 7 & Nd
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. 'NP/m <+ 0z
[ZTD8kF & ^
1205: lock timeout. : L ~ P5
G = #: g/Gsk
1211: the current user has no permission to create a user. } # \ VeoCuP
ZeoD ^ p
1216: failed to check foreign key constraints and failed to update sub-table records. 80Fj "dI % F
> 3} {5 $ x"
1217: failed to check the foreign key constraints. failed to delete or modify the primary table record. FBfggVF
'Ln GTu
1226: the resource used by the current user has exceeded the allowed Resource. please restart the database or the server. ; WKJtdgC
; 22L3Uu9
1227: You are not authorized to perform this operation. 6 pCAs [{n
!;~ I" 1235: the MySQL version is too low and does not have this function. , TyAd-I/
A & = # + v ^
1250: the client does not support the authentication protocol required by the server. please consider upgrading the client. (Y & jT1wu (M
~ HH;: iX7G
1251: the Client does not support authentication protocol requirements. m & $ Ce {
Client does not support authentication protocol requested by server; consider upgrading MySQL client w: M' nO ^ <
I ^ zlwp ^
Quote: {@ D; wskj
Method 1: mysql> set password * $> | nv0F)
-> 'Some_user' @ 'some_host '= OLD_PASSWORD ('newpwd'); ZCB {kc
R f: ^ w
Run the following Command in MySQL Command Line Client: Ud [OW | I
O cQlz"
Set password for root @ localhost = old_password ('20140901');> yd XKyFbR1P
Method 2: "'s? | F6, H
PSPWYeY7
Mysql> UPDATE mysql. user SET Password = OLD_PASSWORD ('newpwd') yAo-3Z0
-> WHERE Host = 'some _ host' AND User = 'some _ user'; i8. YQi
Mysql> flush privileges; WXE) U [^ 5 K
Q! 9 @ yUkap
Modify the red part according to your actual situation. MB6qu (A % r
'E>-ur}
1267: invalid mixed character set. | _~
D6? K # Z' xz
2002: The server port is incorrect. please contact the space provider for the correct port. | 'B & T _
1R ^ ~! TK; @ G
2003: MySQL service is not started. please start this service. YuNb>'
6dn "tsjT
2008: MySQL client ran out of memory} S/FRnj
The error points to MySQL. The reason for this error is that the customer does not have enough memory to store all results. B [; |
EC-3 & (f
2013: remote connection to the database is sometimes caused by the loss of connection when the MySQL server executes an SQL statement. J0 \ 9 ?!
BG/0 ,~ 9
10048: % g $ Xwy4 @
]} FRD $ Oy
Quote: Tm? :. 1 'fj
We recommend that you modify the maximum number of connections in the my. ini file, 38L ^ x) e @
Change the mysql_connect () method to the mysql_pconnect () method.> MpV
To modify mysql_pconnect (), you can go to SQL _config.php in the data directory of the Forum to c> 3Slj]
$ Pconnect = 0; // whether the connection is persistent = mSYI \ q
Change to $ pconnect = 1; 9 VTmh + cQ
Enable anti-refresh. do not refresh too quickly. & lPr \ FSGg
Kf +; Y {0
10055: no cache space available W, 05 k {$}
^ DK ^ WNk %
Quote: NyIu $ V
Check whether your drive C is full and clear some useless files. B5qRt ^ 0 h [
You can enable "process optimization" in "Forum core settings", "core function settings", and "GZIP compression Output" in the background to disable. vG/@ "8DYs
I found the cause of the error 10055 (no cache space available) and analyzed the configuration file of my. ini, as shown in my. ini: [Z {z. v
Default-storage-engine = INNODB UrmRf
Innodb_additional_mem_pool_size = 2 M "SnKY # 0F
Innodb_flush_log_at_trx_commit = 1 (! (Wcu
Innodb_log_buffer_size = 1 M IUs4SaER
Innodb_buffer_pool_size = 10 m '? P % BluZ
Innodb_log_file_size = 10 M} qqcg u
Innodb_thread_concurrency = 8 Uk \ OUDf \ +
I think we can increase innodb_buffer_pool_size = 10 M, for example, 1000 M or M # 9l % W6 {=
The above is the 8 & e G I of mysql5
Ven) aK
For mysql4, you can add the following in my. ini: A $ MpyL R0"
# Innodb_data_file_path = ibdata1: 2000 M; ibdata2: 2000 M d | ^ OtHS "$
# Innodb_data_home_dir = c: ibdata lk W y l}
# Innodb_log_group_home_dir = c: iblogs zZ8s: {7
# Innodb_log_arch_dir = c: iblogs f [C: JXZ9
# Set-variable = innodb_mirrored_log_groups = 1 r; $ Yh8DamW
# Set-variable = innodb_log_files_in_group = 3-Bly o9Y
# Set-variable = innodb_log_file_size = 5 M RnD) & vt I %
# Set-variable = innodb_log_buffer_size = 8 M & 3 {G2
# Innodb_flush_log_at_trx_commit = 1 An ^ q * pH
# Innodb_log_archive = 0 W [} aCLb _
# Set-variable = innodb_buffer_pool_size = 16 M ~ # RcRm CD
# Set-variable = innodb_additional_mem_pool_size = 2 M Xu % p: Ola
# Set-variable = innodb_file_io_threads = 4% S8Js [H ~
# Set-variable = innodb_lock_wait_timeout = 50 5} C7 yo L
Move the previous # to + cE {-dkr
-K? 6? $ EH
10061: ppiRUNUlZ
=-BR $ \ W
Quote:; TW: Q7P
Start the MySQL service CJ> n # s =) on this machine)
For example, if the service fails to be started
It must have been an error in your my. ini file: iCd * MySQL service cannot be started normally @ Jt? # V5K.
After you delete it, MySQL runs according to its default configuration. An & (k [} I
Then there is no problem.