1

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?

Improve this question
7
  • 3
    MySQL on Windows is case insensitive, but Linux is case sensitive. Is name of table in correct case? Commented Jan 16, 2022 at 16:17
  • 1
    If the problem turns out to be the case of the table names (Credits to @Boris). see here. There is a way to make MySql behave ok on both Windows and Linux if this is the case. stackoverflow.com/questions/6134006/… Commented Jan 16, 2022 at 16:26
  • yes I think its the case, but how do I modify it? Commented Jan 16, 2022 at 16:55
  • the "my.cnf" file is empty. I write "lower_case_table_names=0" in it and then after I run mysql it says it doesnt recognise the variable. what do I need to write ib my.cnf because I really dont understand Commented Jan 16, 2022 at 17:05
  • 1
    It is better to change mysql case sensitivity setting. make it case insensitive. Commented Jan 16, 2022 at 18:07

1 Answer 1

Reset to default
4

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.