In recent development, I tried to connect MySQL database locally in my C# application, and it worked fine. But when I created the same database and tables using sql script in Ubuntu, and using the same application to connect the mysql database, below error/exception occurred:
Table ‘SOME_TABLE’ doesn’t exist
Logging into MySQL and I found the table does exist:
Ultimately, it turns out it is the case–sensitive problem: in windows, this is not a problem, but in Ubuntu it is!
After changing the table name to right case (e.g. table name –> TABLE NAME), it worked fine!