Changing the Case sensitives on tables in Mysql

HI ,

This is Problem i faced in My Project .

i have a Table "Cricket" in my database on linux machine.

>>> This is my Sql Command : select * from cricket;

O/p: And the Dataabase through me an error message saying that table name "cricket" doesn't exists on particular database.

i Observed that on some linux machines database tables are case sensitive .

This is the Procedure i followed;

Change the Case sensitives feature on the Mysql database.

like adding the below line to the file /etc/my.cnf

Line : lower_case__table_names=1

to the file " /etc/my.cnf'

is all set now

Thanks,Sekhar