ERROR 1146 (42S02): Table ' eip_fileservice.t_document_file ' doesn ' t exist

One: Problem description

Mysql> select * from T_document_file limit 2;
ERROR 1146 (42S02): Table ' eip_fileservice.t_document_file ' doesn ' t exist

Two: The cause of the error

This is because the variable lower_case_table_names = 1 in the configuration file is caused.

The table name was originally capitalized, but was automatically converted to lowercase in the query, so MySQL could not find the table.

III: Solutions

Modify the configuration file to Lower_case_table_names = 0

Restart database in effect

Note: It is not case-sensitive under Windows, that is, the parameter is not valid.