Mysql Error 1146 Tabel doen't exist Error caused by high-Case sensitivity in MySql, tabeldoen

Mysql Error 1146 Tabel doen't exist Error caused by high-Case sensitivity in MySql, tabeldoen

MySql Error 1146 Tabel doen't exist. Generally, the table does not exist, or the table name is incorrect and the permission is incorrect.

I encountered this problem today. I checked it several times and confirmed it was correct. I tried select in phpMyAdmin to query the data. Check the permissions and make sure that the mysql user has all permissions. What is this error? After querying some information, I found that if the mysql engine is incorrect, it may cause the real tables to be inaccessible, but the engine is myisam.

I am so worried. Where is the error? After searching for another half a day, there is still no result. Looking at the error code for a while, I suddenly found a detail that has been ignored by me. The detailed error code is Tabel ABC doen't exist. The table name here is in uppercase, the name of the table in the database is abc (Ma Dong Note: for example only, this table is not available), which is in lower case. In phpMyAdmin, use the capital table name ABC to try the select statement. The error message Tabel ABC doen't exist is displayed.

Here, the problem is clearly visible, because it is ignored by me: On windows Server, mysql Data Tables are case-insensitive, while linux server is case-sensitive by default. If the linux server is not sensitive to uppercase or lowercase letters, find/etc/my. cnf and add a line under [mysqld]: lower_case_table_names = 1. (Ma Dong Note: lower_case_table_names is 0 by default, and the table name is case sensitive. If it is changed to 1, it is case insensitive ). If you do not have the permission to modify the server configuration, note that the names of each table must be case-insensitive.

If you do not pay attention to small details, it will often waste a lot of time. Details determine success or failure.