I tried setting lower_case_table_names = 1 in /opt/lampp/etc/my.conf. I am using XAMPP 1.7 on Ubuntu 9.04 server
After several attempts and restarts the variable doesn't seem to take effect. I queried using
mysqladmin -u root variables | grep "lower_case_table_names"
and get the output 0
I am planning to switch to mysql from Ubuntu repo but before that wanted to check if I am missing something or is this a bug. The documentation of XAMPP suggests this is the right conf file.