I made some changes in my environment in my.cnf of mysql server. one of those change was setting lower_case_table_names=1 and restarted mysql server.

My application is now throwing error "Table ‘db_name.table_name’ doesn’t exist" for one of the table where table name was in camel-case.

I tried to revert the change in config file and restart mysql server but issue still persist.

When I run show global variables like "lower%"; below is the response –

mysql> show global variables like "lower%";  +------------------------+-------+  | Variable_name          | Value |  +------------------------+-------+  | lower_case_file_system | OFF   |  | lower_case_table_names | 1     |  +------------------------+-------+  2 rows in set (0.00 sec) 

Please help if there is a way to reset the value of lower_case_table_names variable to it’s default or if there is a way to retrieve the data of this particular table.