:: DEVELOPER ZONE
MySQL Reference Manual :: A Problems and Common Errors
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 6 Replication in MySQL
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- A.1. How to Determine What Is Causing a Problem
- A.2. Common Errors When Using MySQL Programs
- A.2.1.
Access denied - A.2.2.
Can't connect to [local] MySQL server - A.2.3.
Client does not support authentication protocol - A.2.4. Password Fails When Entered Interactively
- A.2.5.
Host 'host_name' is blocked - A.2.6.
Too many connections - A.2.7.
Out of memory - A.2.8.
MySQL server has gone away - A.2.9.
Packet too large - A.2.10. Communication Errors and Aborted Connections
- A.2.11.
The table is full - A.2.12.
Can't create/write to file - A.2.13.
Commands out of sync - A.2.14.
Ignoring user - A.2.15.
Table 'tbl_name' doesn't exist - A.2.16.
Can't initialize character set - A.2.17. File Not Found
- A.2.1.
- A.3. Installation-Related Issues
- A.4. Administration-Related Issues
- A.5. Query-Related Issues
- A.5.1. Case Sensitivity in Searches
- A.5.2. Problems Using
DATEColumns - A.5.3. Problems with
NULLValues - A.5.4. Problems with Column Aliases
- A.5.5. Rollback Failure for Non-Transactional Tables
- A.5.6. Deleting Rows from Related Tables
- A.5.7. Solving Problems with No Matching Rows
- A.5.8. Problems with Floating-Point Comparisons
- A.6. Optimizer-Related Issues
- A.7. Table Definition-Related Issues
- A.8. Known Issues in MySQL
This appendix lists some common problems and error messages that you may encounter. It describes how to determine the causes of the problems and what to do to solve them.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.