windows - Make mysql case sensitive?

I wrote

select * from mytable

In my ASP.net app on Windows it works fine. On Linux it complains I used mytable instead of MyTable. How do I set MySQL on Windows to be case sensitive or set Linux to be case insensitive when dealing with table names?

Answer

See 8.2.2. Identifier Case Sensitivity in the mySQL manual.

Short version: Use the lower_case_table_names system variable to achieve case insensitivity on Linux/Unix.