- B.1.2 Common Errors When Using MySQL Programs
- B.1.2.1 Access denied
- B.1.2.2 Can't connect to [local] MySQL server
- B.1.2.3 Client does not support authentication protocol
- B.1.2.4 Password Fails When Entered Interactively
- B.1.2.5 Host 'host_name' is blocked
- B.1.2.6 Too many connections
- B.1.2.7 Out of memory
- B.1.2.8 MySQL server has gone away
- B.1.2.9 Packet too large
- B.1.2.10 Communication Errors and Aborted Connections
- B.1.2.11 The table is full
- B.1.2.12 Can't create/write to file
- B.1.2.13 Commands out of sync
- B.1.2.14 Ignoring user
- B.1.2.15 Table 'tbl_name' doesn't exist
- B.1.2.16 Can't initialize character set
- B.1.2.17 'File' Not Found and Similar Errors
If you get either of the following errors, it usually means that no table exists in the default database with the given name:
Table 'tbl_name' doesn't exist Can't find file: 'tbl_name' (errno: 2)
In some cases, it may be that the table does exist but that you are referring to it incorrectly:
Because MySQL uses directories and files to store databases and tables, database and table names are case sensitive if they are located on a filesystem that has case-sensitive filenames.
Even for filesystems that are not case sensitive, such as on Windows, all references to a given table within a query must use the same lettercase.
You can check which tables are in the default database with
SHOW TABLES. See 項12.5.4. 「SHOW 構文」.
