MySQL common error code

Source: Internet
Author: User
Tags pconnect mysql command line

130: the file format is incorrect. (The error is not clear yet)

145: the file cannot be opened.

1005: An error occurred while creating the MYSQL table.
  
1006: MYSQL database creation failed
  
1007: the MYSQL database already exists. An error occurred while creating the database.
  
1008: the MYSQL database does not exist. An error occurred while deleting the database.
  
1009: MYSQL cannot delete database files, leading to database deletion failure.
  
1010: MYSQL cannot delete the data directory, leading to database deletion failure.
  
1011: MYSQL failed to delete the database file
  
1012: MYSQL cannot read records from the system table.

1016: the file cannot be opened. Use the background fix or phpmyadmin to fix it.
Quote:
Start => All Programs => attachments => Command Prompt
Enter the hard drive letter of the mysql instance.
Directory of cd mysql
Cd bin
Enter myisamchk-f D: usr/local/mysql/data/bbs/PW_members.MYI
Ps: D: usr/local/mysql/data/bbs is the path of your forum Database
-F is selected based on the actual situation. Generally, you can select-r.
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.
Or use the mysqlcheck command to fix the issue. Specific Method: Use the command line to enter the mysql/bin directory and execute
Mysqlcheck-o-r phpwind-uroot-p
Phpwind indicates the name of your database, and root indicates your database username. Then, you are prompted to enter the password. Then repair
Repeat your database.

1017: the server is shut down illegally, causing damage to the file.

1020: the MySQL record has been modified by another user
  
1021: The remaining space on the hard disk is insufficient. please increase the available space on the hard disk.
  
1022: the MySQL keyword is repeated and the change record fails.
  
1023: An error occurred when MySQL was disabled.
  
1024: MySQL file reading error
  
1025: An error occurred while changing the MySQL name.
  
1026: MySQL file writing error
  
1030: the server may be unstable. (The specific reason is not clear)

1032: MySQL record does not exist
  
1036: the MySQL DATA table is read-only and cannot be modified.
  
1037: The system memory is insufficient. Restart the database or restart the server.
  
1038: MySQL has insufficient memory for sorting. Increase the sorting buffer.
  
1040: Maximum number of connections that MySQL has 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, and restart MySQL.
 
1041: insufficient system memory
  
1042: Invalid Host Name
  
1043: Invalid connection
  
1044: The current MySQL user does not have the permission to access the database
  
1045: MySQL cannot connect to the database. The server, database name, username, or password is incorrect.
Quote:
Method: Make sure that the SQL _config.php user name and password under the Forum data directory are correct. If the user forgets the Database Password,
You can change the password as follows:
If MySQL is running, stop it first.
Start MySQL: bin/safe_mysqld -- skip-grant-tables &
You can access MySQL without a password.
Then
> Use mysql
> Update user set password = password ("new_pass") where user = "root ";
> Flush privileges;

1046: no database is selected.

1048: MYSQL field cannot be blank
  
1049: MYSQL database does not exist
  
1050: mysql data table already exists
  
1051: mysql data table does not exist
  
1054: the MYSQL field does not exist. Create a field by yourself.

1060: this field cannot be inserted because it is repeated.

1062: The field value is repeated and the Database Import fails.
Quote:
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
2. Make sure that the fields with repeated primary codes exist in the relevant data table. If yes, delete this record.
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 ).

1064: MySQL does not support encoding in error messages.

1065: Invalid MySQL SQL statement. The SQL statement is empty.

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

1081: MySQL cannot establish a socket connection
  
1114: the MySQL DATA table is full and cannot accommodate any records
  
1116: too many data tables are opened in MySQL
  
1129: MySQL database exception. Restart the database.
  
1130: MySQL failed to connect to the database. You are not authorized to connect to the database.
  
1133: MySQL database user does not exist

1135: the memory may be insufficient. Please contact the Space Provider.

1141: The current MYSQL user is not authorized to access the database
  
1142: The current MYSQL user is not authorized to access the data table
  
1143: The current MYSQL user is not authorized to access fields in the data table.
  
1146: the mysql data table does not exist or is missing. Please restore the backup data.
  
1147: MYSQL has no permission to access data tables.
  
1149: MYSQL statement syntax error
  
1158: network error. Read error. Check the network connection status.
  
1159: network error. Read timeout. Check the network connection status.
  
1160: network error. A write error occurs. Check the network connection status.
  
1161: network error. Write timeout. Check the network connection status.
  
1062: the MYSQL field value is repeated and the Database Import fails.
  
1169: the MYSQL field value is repeated and the update record fails.
  
1177: MYSQL failed to open the data table.
  
1180: MYSQL failed to submit the transaction
  
1181: MYSQL rollback transaction failed
  
1203: the maximum number of connections established between the current MYSQL user and the database that have reached the database. Increase the number of available database connections or
Restart Database
  
1205: MYSQL lock timeout
  
1211: The current MYSQL user does not have the permission to create a user
  
1216: MYSQL foreign key constraints check failed, failed to update sub-table records
  
1217: MYSQL foreign key constraints check failed, failed to delete or modify the master table record
  
1226: The resource used by the current MYSQL user has exceeded the allowed resource. Restart the database or restart the server.
  
1227: You are not authorized to perform this operation because of insufficient MYSQL permissions.
  
1235: MySQL version is too low and does not have this function

1250: the client does not support the authentication protocol required by the server. Please consider upgrading the client.

1251: the Client does not support the authentication protocol requirements.
Client does not support authentication protocol requested by server; consider upgrading MySQL client
Quote:
Method 1:
Mysql> SET PASSWORD
-> 'Some_user' @ 'some_host '= OLD_PASSWORD ('newpwd ');
Run the following Command in MySQL Command Line Client based on our actual situation:
Set password for root @ localhost = old_password ('20140901 ');

Method 2:
Mysql> UPDATE mysql. user SET Password = OLD_PASSWORD ('newpwd ')
-> WHERE Host = 'some _ host' AND User = 'some _ user ';
Mysql> flush privileges;
<Modify the above part according to your actual situation.>

1267: Invalid mixed character set.

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

2003: MySQL service is not started. Please start this service.

2008: MySQL client ran out of memory
The error points to MySQL. The reason for this error is that the customer does not have enough memory to store all results.

2013: remote connection to the database sometimes causes this problem. When the MySQL server runs an SQL statement
The connection is lost.

10048: Maximum number of connections
Quote:
We recommend that you modify the maximum number of connections in the my. ini file,
Change the mysql_connect () method to the mysql_pconnect () method.
To modify mysql_pconnect (), you can go to SQL _config.php in the data directory of the Forum.
$ Pconnect = 0; // whether the connection is persistent
Change to $ pconnect = 1;
Enable anti-Refresh. Do not refresh too quickly.

10055: no cache space available
Quote:
Check whether your drive C is full and clear useless files.
You can enable "Process Optimization" in "Forum core Settings", "core function Settings", and "gzip compressed output" in the background.
I found the cause of the error 10055 (no cache space available) and analyzed the preparation file of my. ini,
In my. ini:
Default-storage-engine = InnoDB
Innodb_additional_mem_pool_size = 2 M
Innodb_flush_log_at_trx_commit = 1
Innodb_log_buffer_size = 1 M
Innodb_buffer_pool_size = 10 M
Innodb_log_file_size = 10 M
Innodb_thread_concurrency = 8
I think we can increase innodb_buffer_pool_size = 10 M, for example, 1000 M or M.
The above is for mysql5

For mysql4, you can add the following in my. ini:
# Innodb_data_file_path = ibdata1: 2000 M; ibdata2: 2000 M
# 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 = 5 M
# Set-variable = innodb_log_buffer_size = 8 M
# Innodb_flush_log_at_trx_commit = 1
# Innodb_log_archive = 0
# Set-variable = innodb_buffer_pool_size = 16 M
# Set-variable = innodb_additional_mem_pool_size = 2 M
# Set-variable = innodb_file_io_threads = 4
# Set-variable = innodb_lock_wait_timeout = 50
Go to the previous #

10061: MySQL service cannot be started normally
Quote:
Start the MySQL service on this machine
If the service fails to be started, it must have been an error in your my. ini file. The MySQL service cannot be started normally.
After you delete it, MySQL will run according to its default configuration, so there is no problem.

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.