Common error codes for MySQL

Source: Internet
Author: User
Tags mysql delete mysql delete database mysql version pconnect mysql command line

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

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.