MySQL error on Linux: Table "xxx" doesn ' t exist how to solve

problem : Linux on MySQL out table ' xxx ' doesn ' t exist error

cause : MySQL on Linux defaults to case-sensitive results.

Fix : Change MySQL configuration file, in my.cnf [mysqld] below (position cannot be wrong) Add lower_case_table_name=1 this sentence (1 means case-insensitive, 0 case sensitive), save restart MySQL.

No my.cnf file, if the default installation performs the following column actions

[Root@hqw mysql]# cp/usr/share/mysql/my-huge.cnf/etc/my.cnf

Then my.cnf add the configuration information