In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved?

In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved?

In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved?

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 in my. cnf

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address: