Mysql Error Code List
Contents |
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial MySQL mysql error php Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure
Mysql Errors And Solutions
Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High mysql sqlstate Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL mysql errors log 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to
Mysql Error Code 1062
MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrictions and Limits Indexes My
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration mysql sqlstate 45000 Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL mysql codes list Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning Stored
Mysql Codes For Creating Tables
Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of http://dev.mysql.com/doc/en/error-messages-server.html memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.6Mb PDF (A4) - 35.6Mb PDF (RPM) - 34.6Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.4Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc Plugin (Zip) - 11
Error Codes MySQL Error Codes Windows System Errors About this database This is a free public resource. It is unmoderated https://www.briandunning.com/error-codes/?source=MySQL and operates on the "public virtue" system. I hope you find http://www.fromdual.com/mysql-error-codes-and-messages-1000-1049 it useful! 1000SQLSTATE: HY000 (ER_HASHCHK) hashchk1001SQLSTATE: HY000 (ER_NISAMCHK) isamchk1002SQLSTATE: HY000 (ER_NO) NO1003SQLSTATE: HY000 (ER_YES) YES1004SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file '%s' (errno: %d)1005SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Can't create table '%s' (errno: %d)1006SQLSTATE: HY000 (ER_CANT_CREATE_DB) Can't create database '%s' (errno: %d)1007SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Can't create database mysql error '%s'; database exists1008SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Can't drop database '%s'; database doesn't exist1009SQLSTATE: HY000 (ER_DB_DROP_DELETE) Error dropping database (can't delete '%s', errno: %d)1010SQLSTATE: HY000 (ER_DB_DROP_RMDIR) Error dropping database (can't rmdir '%s', errno: %d)1011SQLSTATE: HY000 (ER_CANT_DELETE_FILE) Error on delete of '%s' (errno: %d)1012SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC) Can't read record in system table1013SQLSTATE: HY000 (ER_CANT_GET_STAT) Can't get status of '%s' mysql error code (errno: %d)1014SQLSTATE: HY000 (ER_CANT_GET_WD) Can't get working directory (errno: %d)1015SQLSTATE: HY000 (ER_CANT_LOCK) Can't lock file (errno: %d)1016SQLSTATE: HY000 (ER_CANT_OPEN_FILE) Can't open file: '%s' (errno: %d)1017SQLSTATE: HY000 (ER_FILE_NOT_FOUND) Can't find file: '%s' (errno: %d)1018SQLSTATE: HY000 (ER_CANT_READ_DIR) Can't read dir of '%s' (errno: %d)1019SQLSTATE: HY000 (ER_CANT_SET_WD) Can't change dir to '%s' (errno: %d)1020SQLSTATE: HY000 (ER_CHECKREAD) Record has changed since last read in table '%s'1021SQLSTATE: HY000 (ER_DISK_FULL) Disk full (%s); waiting for someone to free some space...1022SQLSTATE: 23000 (ER_DUP_KEY) Can't write; duplicate key in table '%s'1023SQLSTATE: HY000 (ER_ERROR_ON_CLOSE) Error on close of '%s' (errno: %d)1024SQLSTATE: HY000 (ER_ERROR_ON_READ) Error reading file '%s' (errno: %d)1025SQLSTATE: HY000 (ER_ERROR_ON_RENAME) Error on rename of '%s' to '%s' (errno: %d)1026SQLSTATE: HY000 (ER_ERROR_ON_WRITE) Error writing file '%s' (errno: %d)1027SQLSTATE: HY000 (ER_FILE_USED) '%s' is locked against change1028SQLSTATE: HY000 (ER_FILSORT_ABORT) Sort aborted1029SQLSTATE: HY000 (ER_FORM_NOT_FOUND) View '%s' doesn't exist for '%s'1030SQLSTATE: HY000 (ER_GET_ERRNO) Got error %d from storage engine1031SQLSTATE: HY000 (ER_ILLEGAL_HA) Table storage engine for '%s' doesn't have this option1032SQLSTATE: HY000 (ER_KEY_NOT_FOUND) Can't find record in '%s'1033SQLSTATE: HY000 (ER_NOT_FORM_FI
hashchk Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK) Message: isamchk Error: 1002 SQLSTATE: HY000 (ER_NO) Message: NO Error: 1003 SQLSTATE: HY000 (ER_YES) Message: YES Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Message: Can't create file '%s' (errno: %d) Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: %d) Error: 1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database '%s' (errno: %d) How does the MySQL error message look like? mysql> CREATE DATABASE test; ERROR 1006 (HY000): Can't create database 'test' (errno: 13) What does the MySQL error message mean? The MySQL Server (mysqld process) can, for whatever reason, NOT create a schema/database. Additional information you can get as follows: shell> perror 13 OS error code 13: Permission denied When does this MySQL error message happen? This MySQL error usually happens when the MySQL data directory (datadir) does not belong to the user under which the mysqld process runs. For example the data directory belongs to the user root and the mysqld process runs as user mysql. How to fix this MySQL error? If the MySQL data directory does not belong to the user the mysqld process is running under, you can fix this for example as follows: shell> sudo su - shell> cd /var/lib shell> chown -R mysql:mysql mysql Alternatively you can start the mysqld process as follows: shell> bin/mysqld_safe --user=mysql or set the user accordingly in your my.cnf file. # my.cnf [mysqld] user = mysql Error: 1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists How does the MySQL error message look like? mysql> CREATE SCHEMA test; ERROR 1007 (HY000): Can't create database 'test'; database exists What does the MySQL error message mean? MySQL (the mysqld process) can, for whatever reason NOT create a schema/database. When does this MySQL error message happen? This MySQL error apears, as the error message states, when the database already exists. How to fix this MySQL error? You have 2 possiblities: Choose an other name for your new database / schema