Mysql on linux reports Table & #39; xxx & #39; doesn & #39; t exist error solution, mysqlexist

Mysql on linux reports Table 'xxx' doesn' t exist error solution, mysqlexist
Mysql on linux reports Table 'xxx' doesn' t exist error Solution
Problem: The program reports the error of Table 'xxx' doesn' t exist, but the database shows that the Table already exists and the letters are not spelled correctly.
Cause: mysql in 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.
The my. cnf file does not exist. If it is installed by default, perform the following operations:
[Root @ hqw mysql] # cp/usr/share/mysql/my-huge.cnf/etc/my. cnf
Add configuration information to my. cnf.