Common error tips and solutions for MySQL

Source: Internet
Author: User
Tags empty flush connect sql mysql mysql client mysql version variable

130: The file format is not correct. (Not very clear of the wrong situation)

145: File cannot be opened.

1005: Failed to create table.

1006: Failed to create database.

1007: Database already exists, database creation failed.

1008: Database does not exist, delete database failed.

1009: Unable to delete the database file caused the database to be deleted failed.

1010: Unable to delete the data directory caused the database to be deleted failed.

1011: Failed to delete database file.

1012: Cannot read the records in the system table.

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

Quote:

Start => All Programs => Attachments => command Prompt

Enter MySQL on the hard drive letter

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 can also choose-r

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

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

Mysqlcheck-o-R Phpwind-uroot-p

Where Phpwind is your database name, root is your database username, and then prompts you to enter the password. Then you'll be able to fix your database.

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

1020: The record has been modified by another user.

1021: The hard disk space is insufficient, please increase the hard disk free space.

1022: Duplicate the keyword, change record failed.

1023: An error occurred while closing.

1024: Error reading file.

1025: An error occurred while changing the name.

1026: Error writing file.

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

1032: The record does not exist.

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

1037: The system is low on memory, please reboot the database or reboot the server.

1038: There is not enough 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 connections available to the database.

Quote:

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

1041: System memory is low.

1042: Invalid host name.

1043: Invalid connection.

1044: Database user permissions are not sufficient, please contact the space provider to resolve.

1045: Database Server/Database username/database name/Database password error, please contact the space provider to check the account.

Quote:

Methods: Ensure that the sql_config.php username and password are correct in the Forum data directory. If the user forgets the password for the database, the password can be modified as follows:

If MySQL is running, stop first.

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

You can enter MySQL without the need for a password.

Then it's

The following are the referenced contents:
>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 data table already exists.

1051: The data table does not exist.

1054: field does not exist, set up the field itself.

1060: The field repeats, causing the field to not be inserted.

1062: Duplicate field values, storage failed

Quote:

1. If you have an error similar to the main code "65535", you can view the self added field of the related table and change the field value to

2. Ensure that the fields in the related datasheet are duplicated, if there is a deletion of this record

3. Back up the database, repair the related table (Note: This situation is more common, such as pw_posts table, repair the table do not forget to back up)

1064:mysql does not support encoding in error prompts.

1065: Invalid SQL statement, empty SQL statement.

The 1067:mysql version is 5 and does not support null default values.

1081: Unable to establish Socket connection.

1114: The data table is full and cannot hold any records.

1115: Set the character set in MySQL and not supported.

1116: There are too many open data tables.

1129: The database has an exception, please restart the database.

1130: Failed to connect to the database, no permissions to connect to the database.

1133: The database user does not exist.

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

1141: The current user is not authorized to access the database.

1142: The current user is not authorized to access the datasheet.

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

1146: The data table is missing, please restore the backup data

1147: User access to the data table is not defined.

1149:sql statement syntax error.

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

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

1160: Network error, there is a write error, please check the network connection status.

1161: Network error, write timeout, check network connection status.

1169: Duplicate field value, update record failed.

1177: Failed to open data table.

1180: Commit transaction failed.

1181: ROLLBACK TRANSACTION failed.

1193: Character Set qualification (set NAMES) is not supported.

1203: The current user and database connection 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: FOREIGN KEY constraint check failed, update child table record failed.

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

1226: The current user is using more resources than is allowed, please reboot the database or reboot the server.

1227: Insufficient permissions, you do not have permission to do this operation.

1235:mysql version is too low, does not have this function.

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 ');

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

Set password for root@localhost = Old_password (' 123456 ');

Method 2:

The following are the referenced contents:
mysql> UPDATE mysql.user SET Password = Old_password (' newpwd ')
-> WHERE Host = ' some_host ' and User = ' some_user ';
mysql> FLUSH privileges;

The red section above please revise according to oneself actual situation.

1267: illegal mixed character set.

2002: The server port is not correct, please consult the space provider the right port.

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

2008:mysql client ran out of memory

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

2013: Remote connection to the database is sometimes the problem, the MySQL server in the execution of a SQL statement when the loss of connectivity caused.

10048:

Quote:

It is recommended to modify the maximum number of connections in the My.ini file and to change the mysql_connect () method to the Mysql_pconnect () method.
To modify Mysql_pconnect (), you can $pconnect = 0 in the sql_config.php of the forum's data directory; Whether the persistent connection is modified to $pconnect = 1; turn on anti-refresh

10055: No cache space available

Quote:

Check to see if your C-disk space is full, and remove any files that are not in use.

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

Looked up the 10055 (no cache space available) The cause of the error, analyzed the My.ini configuration file, in the My.ini as follows:

The following are the referenced contents:
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, you can add the following in My.ini:

The following are the referenced contents:
#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:

Quote:

Start the MySQL service on this machine

If the service fails to start

There must be something wrong with your My.ini file.

MySQL service does not start properly

After you delete it, MySQL will run on its default configuration,

Then there's no problem.



Related Article

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.