Common error codes for MySQL

130: The file format is incorrect. (It's not clear what the wrong situation is)

145: File could not be opened.

1005:mysql Creating table Failed

　　

1006:mysql failed to create database

　　

1007:mysql database already exists, database creation failed

　　

1008:mysql database does not exist, deleting database failed

　　

1009:mysql Unable to delete database file causes database failure to be deleted

　　

1010:mysql Unable to delete data directory causes database failure to be deleted

　　

1011:mysql Delete database file failed

　　

1012:mysql cannot read records in system tables

1016: File cannot be opened, use background repair or use phpMyAdmin to repair.

Quote:

Start and all Programs = = Accessories + = Command Prompt

Enter the hard drive letter of your MySQL

directory where CD MySQL resides

CD bin

Enter Myisamchk-f d:usr/local/mysql/data/bbs/pw_members. MYI

Ps:d:usr/local/mysql/data/bbs is the path to your forum database

-F Depending on the circumstances of the choice, generally also can choose-r

Note that your system C disk or put the database of hard disk space is sufficient, generally less than 1G is prone to errors.

or fix it with the Mysqlcheck command. Specific method: Use the command line to enter the Mysql/bin directory, execute

Mysqlcheck-o-R Phpwind-uroot-p

Where Phpwind is the name of your database, root is your database user name, and you will be prompted to enter your password. And then they'll fix it.

Re-copy your database.

1017: The server is illegally shutting down, causing the file to become corrupted.

1020:mysql record has been modified by another user

　　

1021: Insufficient space on the hard drive, please increase the hard disk free space

　　

1022:mysql keyword Repeat, change record failed

　　

1023:mysql An error occurred while shutting down

　　

1024:mysql Read File Error

　　

1025:mysql An error occurred while changing the name

　　

1026:mysql Write File Error

　　

1030: The server may be unstable. (The specific reason is not very clear)

1032:mysql record does not exist

　　

The 1036:mysql data table is read-only and cannot be modified

　　

1037: Insufficient system memory, please restart the database or restart the server

　　

1038:mysql Insufficient memory for sorting, increase the sort buffer

　　

1040:mysql the maximum number of connections that have reached the database, increase the number of available connections to the database

Quote:

In My.ini modify max_connections=100 to max_connections=1000 or greater, restart MySQL

　

1041: Insufficient system memory

　　

1042: Invalid host name

　　

1043: Invalid connection

　　

1044:mysql The current user does not have permission to access the database

　　

1045:mysql cannot connect to database, server, database name, user name or password error

Quote:

Method: Ensure that the sql_config.php user name and password are correct in the Forum data directory. If the user forgets the password for the database,

You can change the password as follows:

If MySQL is running, stop first.

Start Mysql:bin/safe_mysqld--skip-grant-tables &

You can go to MySQL without a password.

Then there is

>use MySQL

>update User Set Password=password ("New_pass") where user= "root";

>flush privileges;

1046: No database selected.

1048:mysql field cannot be empty

　　

1049:mysql database does not exist

　　

1050:mysql data table already exists

　　

1051:mysql data table does not exist

　　

1054:mysql field does not exist, self-established field

1060: The field is duplicated, which prevents the field from being inserted.

1062: Duplicate field value, inbound failed

Quote:

1. If there is an error similar to "65535" in the main code, you can view the self-increment field of the related table and change the field value to

2. Ensure that the duplicate field of the main code in the relevant data table exists, and if it exists, delete the record

3. Back up the database and fix the related tables (note: This is a common situation, such as the pw_posts table, do not forget to repair the table when the backup).

1064:mysql does not support encoding in the error prompt.

1065:MYSQL Invalid SQL statement, SQL statement is empty

The 1067:mysql version is 5, and the null default value is not supported.

1081:mysql cannot establish socket connection

　　

1114:mysql Data Sheet is full and cannot hold any records

　　

1116:mysql too many Open data tables

　　

1129:mysql database has an exception, please restart the database

　　

1130:mysql connection to database failed with no permissions to connect to database

　　

1133:mysql database user does not exist

1135: May not be enough memory, please contact the space provider to resolve.

1141:mysql the current user is not authorized to access the database

　　

1142:mysql The current user does not have access to the data table

　　

1143:mysql The current user does not have access to the fields in the datasheet

　　

1146:mysql data table does not exist or data table is missing, please restore backup data

　　

1147:mysql user access to a data table is undefined

　　

1149:mysql statement Syntax error

　　

1158: Network error, read error, please check network connection status

　　

1159: Network error, read timeout, check network connection status

　　

1160: Network error, write error, please check network connection status

　　

1161: Network error, write timeout, please check network connectivity status

　　

1062:mysql field value repeated, storage failed

　　

1169:mysql field value repeats, update record failed

　　

1177:mysql Open Data table failed

　　

1180:mysql COMMIT TRANSACTION failed

　　

1181:mysql ROLLBACK TRANSACTION Failure

　　

1203:mysql the current user and database have reached the maximum number of connections to the database, increase the number of available database connections or

Restart database

　　

1205:mysql Plus lock timeout

　　

1211:mysql The current user does not have permission to create a user

　　

1216:mysql FOREIGN KEY constraint check failed, update child table record failed

　　

1217:mysql FOREIGN KEY constraint check failed, delete or modify master table record failed

　　

1226:mysql the current user is using more resources than allowed, please restart the database or restart the server

　　

1227:mysql permissions are insufficient, you do not have permission to do this

　　

1235:mysql version is too low to have this feature

1250: The client does not support the authentication protocol required by the server, please consider upgrading the client.

1251:client cannot support authentication protocol's requirements

Client does authentication protocol requested by server; Consider upgrading MySQL client

Quote:

Method 1:

Mysql> SET PASSWORD for

' Some_user ' @ ' some_host ' = Old_password (' newpwd ');

In combination with our actual situation, run under MySQL Command line Client:

Set password for [email protected] = Old_password (' 123456 ');

Method 2:

mysql> UPDATE mysql.user SET Password = Old_password (' newpwd ')

-WHERE Host = ' some_host ' and User = ' some_user ';

mysql> FLUSH privileges;

< The above section, please amend according to your actual situation. >

1267: illegal mixed character set.

2002: The server port is not correct, please consult the proper port of the space quotient.

The 2003:mysql service does not start, please start the service.

2008:mysql client ran out of memory

The error points to MySQL client MySQL. The reason for this error is simple, and the customer does not have enough memory to store all the results.

2013: Remotely connecting to a database sometimes this problem occurs when the MySQL server executes an SQL statement

caused by a loss of connectivity.

10048: The maximum number of connections and so on

Quote:

We recommend that you modify the maximum number of connections in the My.ini file.

The mysql_connect () method is changed to the Mysql_pconnect () method.

To modify Mysql_pconnect (), you can do so in the sql_config.php of the data directory of the Forum

$pconnect = 0; Whether the connection is persistent

Modified into $pconnect = 1;

Turn on anti-refresh, it is forbidden to refresh too fast.

10055: No cache space available

Quote:

Check to see if your C space is full, and clear some unused files.

Can be in the background of "forum core settings", "Core function Settings" in "Process optimization" turned on, "GZIP compressed output" off.

Find out 10055 (no cache space available) cause of the error, analyzed the My.ini configuration file,

In My.ini, the following:

Default-storage-engine=innodb

Innodb_additional_mem_pool_size=2m

Innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1m

innodb_buffer_pool_size=10m

innodb_log_file_size=10m

Innodb_thread_concurrency=8

Think you can increase the innodb_buffer_pool_size=10m like 100M or 1000M.

The above is for the MYSQL5

If it is mysql4 can be added in My.ini as follows:

#innodb_data_file_path = ibdata1:2000m;ibdata2:2000m

#innodb_data_home_dir = C:ibdata

#innodb_log_group_home_dir = C:iblogs

#innodb_log_arch_dir = C:iblogs

#set-variable = Innodb_mirrored_log_groups=1

#set-variable = innodb_log_files_in_group=3

#set-variable = innodb_log_file_size=5m

#set-variable = innodb_log_buffer_size=8m

#innodb_flush_log_at_trx_commit =1

#innodb_log_archive =0

#set-variable = innodb_buffer_pool_size=16m

#set-variable = innodb_additional_mem_pool_size=2m

#set-variable = innodb_file_io_threads=4

#set-variable = innodb_lock_wait_timeout=50

To the front of the #

10061:mysql service does not start properly

Quote:

Start the MySQL service on this machine

If the service failed to start, it must be your My.ini file error, the MySQL service does not start normally

When you delete it, MySQL runs on its default configuration, so there's no problem.

The above information is based on all aspects of online information integration.

If there is any explanation, please follow the thread, I will amend it.

The above method is not necessarily effective, if we have other solutions can also be proposed, let us together to improve!

This article is from the "System World" blog, please be sure to keep this source http://sgk2011.blog.51cto.com/1551358/1825308

Common error codes for MySQL