MySQL error 1146 tabel doen ' t exist errors caused by case sensitive problem _mysql

MYSQL Error 1146 tabel doen ' t exist, in general, the table does not exist, or the table name is wrong, permission issues.

Today encountered this problem, carefully check several times, confirm the correct, and in the phpMyAdmin to try Select, you can query the data. Also check the permissions to confirm that the MySQL user has all the permissions. What about this mistake? After querying for some information, it was found that if the MySQL engine was not correct, it would be inaccessible to a real-life table, but the engine was MyISAM.

This is a worry, where is the error? Looking for a long time, still no fruit. Innocent look at this section of the error code, a daze for a half-day, suddenly found a detail that has been overlooked by me, detailed error code for tabel ABC doen ' t exist, where the table name is uppercase, and the table in the database named ABC (horse Winter Note: For example, no this table), is lowercase. In phpMyAdmin, an uppercase table named ABC tries to select, and the error prompts tabel ABC Doen ' t exist.

Here, the problem is clearly visible, because of a problem I overlooked: Under Windows Server, MySQL's data tables are case-insensitive, while Linux servers are case-sensitive by default. If the Linux server is to be modified to be case insensitive, you can find/etc/my.cnf and add a line under [mysqld]: Lower_case_table_names=1. (Horse winter Note: Lower_case_table_names By default is 0, and table name is case sensitive, modified to 1, that is, case insensitive). If you do not have permission to modify the server configuration, be aware that each table name that appears will be case-sensitive.

Not paying attention to small details often wastes a lot of time. Details determine success or failure.