Mysql Error Numbers
Contents |
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 mysql error php as a Document Store Tutorial MySQL Programs MySQL Server Administration Security mysql errors and solutions Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB mysql sqlstate Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors mysql errors log and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 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
Mysql Error Code 1062
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 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 TEMPORA
Error Codes MySQL Error Codes Windows System Errors About this database This is a free
Mysql Sqlstate 45000
public resource. It is unmoderated and operates on the "public mysql codes list virtue" system. I hope you find it useful! 1000SQLSTATE: HY000 (ER_HASHCHK) hashchk1001SQLSTATE: HY000 (ER_NISAMCHK) isamchk1002SQLSTATE: HY000 mysql codes for creating tables (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 http://dev.mysql.com/doc/en/error-messages-server.html database '%s' (errno: %d)1007SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Can't create database '%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 https://www.briandunning.com/error-codes/?source=MySQL (ER_CANT_FIND_SYSTEM_REC) Can't read record in system table1013SQLSTATE: HY000 (ER_CANT_GET_STAT) Can't get status of '%s' (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'1030SQLSTAT
they could be. But never the less read them carefully. Most of the time http://www.fromdual.com/mysql-error-codes-and-messages they tell you what you need to know... And an http://php.net/manual/en/function.mysql-errno.php other wisdom: Errors are really errors and they have to be solved. Warnings are warnings and you should investigate if they appear. Do not ignore both of them unless you have clearly understood what you are doing. With MySQL: mysql error mysql> SHOW WARNINGS is often your friend! Further sources to find the problems are: mysql> SHOW SLAVE STATUS\G shell> perror
and Objects Namespaces Errors Exceptions Generators References Explained Predefined Variables Predefined Exceptions Predefined Interfaces and Classes Context options and parameters Supported Protocols and Wrappers Security Introduction General considerations Installed as CGI binary Installed as an Apache module Session Security Filesystem Security Database Security Error Reporting Using Register Globals User Submitted Data Magic Quotes Hiding PHP Keeping Current Features HTTP authentication with PHP Cookies Sessions Dealing with XForms Handling file uploads Using remote files Connection handling Persistent Database Connections Safe Mode Command line usage Garbage Collection DTrace Dynamic Tracing Function Reference Affecting PHP's Behaviour Audio Formats Manipulation Authentication Services Command Line Specific Extensions Compression and Archive Extensions Credit Card Processing Cryptography Extensions Database Extensions Date and Time Related Extensions File System Related Extensions Human Language and Character Encoding Support Image Processing and Generation Mail Related Extensions Mathematical Extensions Non-Text MIME Output Process Control Extensions Other Basic Extensions Other Services Search Engine Extensions Server Specific Extensions Session Extensions Text Processing Variable and Type Related Extensions Web Services Windows Only Extensions XML Manipulation Keyboard Shortcuts? This help j Next menu item k Previous menu item g p Previous man page g n Next man page G Scroll to bottom g g Scroll to top g h Goto homepage g s Goto search(current page) / Focus search box mysql_error » « mysql_drop_db PHP Manual Function Reference Database Extensions Vendor Specific Database Extensions MySQL MySQL (Original) MySQL Functions Change language: English Brazilian Portuguese Chinese (Simplified) French German Japanese Korean Romanian Russian Spanish Turkish Oth