Mysql on linux reports Table 'xxx' doesn' t exist error Solution

On linux, mysql reports the error Table 'xxx' doesn' t exist. solution: the program reports the error Table 'xxx' doesn' t exist, however, the database shows that the table already exists and the letters are not spelled correctly. Www.2cto.com: mysql on linux is case sensitive by default. Solution: Modify the mysql configuration file in my. add lower_case_table_name = 1 under [mysqld] In cnf (location cannot be wrong) and save and restart mysql. (1 indicates case insensitive and 0 indicates case sensitive.