Shulou(Shulou.com)05/31 Report--

Mysql in which commonly used error codes, many novices are not very clear, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

A complete collection of common error codes in mysql:

130: the file format is incorrect. It is not very clear about the wrong situation.

145: the file cannot be opened.

1005: failed to create table.

1006: failed to create the database.

1007: database already exists, failed to create database.

1008: database does not exist. Failed to delete database.

1009: the failure to delete the database file caused the deletion of the database.

1010: unable to delete the data directory caused the deletion of the database to fail.

1011: failed to delete database file.

1012: records in the system table cannot be read.

1016: the file cannot be opened, use background repair or use phpmyadmin to repair.

Quote:

Start = > all programs = > attachments = > Command prompt

Enter the letter of the hard drive where the mysql is located

Directory where cd mysql is located

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 choose according to the specific situation, generally you can also choose-r.

Pay attention to whether your system C disk or the hard disk space of the database is enough, 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 and execute:

Mysqlcheck-o-r phpwind-uroot-p

Where phpwind is the name of your database, root is your database user name, and then you will be prompted for a password. Then your database will be repaired.

1017: the server shut down illegally, causing the file to be corrupted.

1020: the record has been modified by another user.

1021: there is not enough space left on the hard disk, please increase the available space on the hard disk.

1022: keyword repeated, failed to change record.

1023: an error occurred while shutting down.

1024: error reading file.

1025: an error occurred while changing the name.

1026: file writing error.

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

1032: record does not exist.

1036: the datasheet is read-only and cannot be modified.

1037: the system is out of memory. Please restart the database or the server.

1038: insufficient memory for sorting, please increase the sort buffer.

1040: the maximum number of connections to the database has been reached, please increase the number of available connections to the database.

Quote:

Change max_connections=100 to max_connections=1000 or greater in my.ini and restart mysql.

1041: the system is out of memory.

1042: invalid hostname.

1043: invalid connection.

1044: insufficient database user rights, please contact the space provider to solve the problem.

1045: database server / database user name / database name / database password is incorrect, please contact the space provider to check the account.

Quote:

Method: make sure that the sql_config.php username and password under the forum data directory are correct. If the user forgets the password of the database, he or she can change the password as follows:

If MySQL is running, stop it first.

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

You can enter MySQL without a password.

And then there is:

> use mysql

> update user set password=password ("new_pass") where user= "root"

> flush privileges

1046: no database selected.

1048: the field cannot be empty.

1049: the database does not exist.

1050: the datasheet already exists.

1051: the datasheet does not exist.

1054: the field does not exist. Create the field by yourself.

1060: the field is duplicated so that it cannot be inserted.

1062: duplicate field value and failed to enter the database.

Quote:

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

two。 Make sure that the fields with duplicate master codes exist in the relevant data table, and if so, delete the record.

3. Back up the database and repair the related tables (note: this is quite common, such as the pw_ posts table, don't forget to back up when repairing the table).

1064:MySQL does not support encoding in error prompts.

1065: invalid SQL statement, SQL statement is empty.

The 1067:MySQL version is 5 and empty default values are not supported.

1081: Socket connection cannot be established.

1114: the datasheet is full and cannot hold any records.

1115: the character set is not supported in MySQL.

1116: too many datasheets are open.

1129: there is an exception in the database. Please restart the database.

1130: failed to connect to the database and did not have permission to connect to the database.

1133: the database user does not exist.

1135: there may be not enough memory, please contact the space provider to solve it.

1141: the current user does not have access to the database.

1142: the current user does not have access to the datasheet.

1143: the current user does not have access to the fields in the data table.

1146: the data table is missing. Please restore the backup data.

1147: user access to the datasheet is not defined.

1149:SQL statement syntax error.

1158: network error, read error, please check the network connection status.

1159: network error, read timeout, please check the network connection status.

1160: network error, write error, please check the network connection status.

1161: network error, write timeout, please check the network connection status.

1169: duplicate field value, failed to update record.

1177: failed to open the data table.

1180: failed to commit transaction.

1181: failed to roll back the transaction.

1193: character set qualification (SET NAMES) is not supported.

1203: the current user's connection to the database has reached the maximum number of connections to the database, please increase the number of available database connections or restart the database.

1205: lock timeout.

1211: the current user does not have permission to create a user.

1216: failed to check foreign key constraints and update child table records.

1217: foreign key constraint check failed, delete or modify master table record failed.

1226: the current user has used more resources than allowed. Please restart the database or restart the server.

1227: insufficient permissions, you are not authorized to perform this operation.

The 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 the requirements of authentication protocol.

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Quote:

Method 1:mysql > SET PASSWORD FOR

-> 'some_user' @ 'some_host' = OLD_PASSWORD ('newpwd')

According to our actual situation, run under MySQL Command Line Client:

Set password for root@localhost = 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

Please modify the red part above according to your actual situation.

1267: illegal mixed character set.

2002: the server port is incorrect. Please consult the space provider for the correct port.

The 2003:MySQL service is not started. Please start the service.

2008:MySQL client ran out of memory .

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

2013: this problem sometimes occurs when connecting to a database remotely, when the MySQL server loses the connection while executing a SQL statement.

10048:

Quote:

It is recommended to 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 (), it can be found in sql_config.php in the data directory of the forum.

$pconnect = 0; / / whether persistent connection or not

Modified to $pconnect = 1

Enable anti-refresh. Refresh too fast is strictly prohibited.

10055: there is no cache space available.

Quote:

Check to see if your C disk is full and clear some useless files.

You can turn on "process Optimization" in "Forum Core Settings" and "Core function Settings" and turn off "GZIP Compression output" in the background.

The reason for the error in 10055 (no cache space is available) is found, and the configuration file of my.ini is analyzed as follows in my.ini:

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

I think it is possible to increase the innodb_buffer_pool_size=10M by 100m or 1000m.

If it is mysql4, you can add the following to my.ini:

# 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

Go to the front #.

10061:

Quote:

Start the MySQL service on this machine.

If the service fails to start.

There must be something wrong with your my.ini file. The MySQL service cannot be started properly.

After you delete it, MySQL will run in its default configuration, and there will be no problem.

Add:

Information 1:Error: Access denied for user: 'linanma@localhost' (Using password: YES)

Solution: this is one of the common problems in the novice installation forum. This problem is mainly due to the incorrect account number or password for connecting to the database, which can generally be solved by entering the correct account number and password. If it still cannot be solved, please check whether the attribute of the config.php file in the root directory of the forum is 777. If the attribute is correct, it still cannot be solved. Please use notepad and other text editing software to open config.php and follow the instructions to manually configure the relevant parameters, and then upload to the forum directory.

Information 2:Error: Unknown column 'msignature' in' field list'

Solution: this is generally a problem when installing the plug-in, which should not follow the instructions to add the relevant fields, in which the 'msignature'' in the Unknown column 'msignature' in' field list' text is the name of the missing field, the solution, it is recommended to take a look at the relevant plug-in installation instructions and add relevant fields.

Information 3:Error: Can't open file: 'cdb_forums.MYI'. (errno: 145)

Solution: this error prompt tells you that a data table is corrupted, which is usually caused by a server problem.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.