The program does not have MySQL reports on the Linux server. Error

  

The websites on all Windows
servers were ported to Linux a few days ago, but a series of problems appeared.

The first is the program reported java.sql.SQLException: Table ‘xxx.TB_XXX’ doesn’t exist, but the database table exists.

The query was found to be because the SQL statement used uppercase, but because Linux recognizes case, it reports an error.

The solution is as follows:

Adding #1 in the MySQL configuration file my.cnf [mysqld] means that case insensitive # 0 means case-sensitive lower\\_case\\_table\\_names =1

Restart MySQL service, everything works fine~

Copyright © Windows knowledge All Rights Reserved