[SOLVED] Spring Boot java.sql.SQLSyntaxErrorException: Table 'mydb.table_name' doesn't exist

Issue

The table exists, I use SpringBoot, hibernate to create the tables, mysql for the database... I connect succesfully to the database in the app. The tables are created and all that. My application ran perfectly on Windows. But now I have Linux and it just gives me this error what is it? There is no error in the code this I know for sure its something from the database but I dont know what...any thoughts?

Solution

Just to copy answer from comments. The problem is that Windows is case insensitive but Linux is case sensitive.

MySQL configuration:

[mysqld]
lower_case_table_names=1

Link that @Nandostyle referenced with same issue: Link

Answered By - Boris

Answer Checked By - Dawn Plyler (WPSolving Volunteer)