Question How to set my.cnf to accept both uppercase and lowercase tables

[sailaja]

How to setup mysql my.cnf to accept both uppercase and lowercase tables.

Environment:
Os: Ubuntu 14.04 TLS
Mysql Server:
App Server: Weblogic Server 12.2.1 (Only uppercase tables are accepted)
Plesk: 12.0.8 (Only lowercase tables are accepted)

I try

lower_case_table_names=2 #(default value '0')

Error message:

database.table doesn't exist

if i use

lower_case_table_names=1
The WLserver work fine but my Wiki, plesk .... have problems

How could i deal with this issue?

 

[mab27]

Does anyone have an idea to solve the problem?
calivita

 

[robert222]

i have the same problem.
i found this line in my.cnf

4. "~/.my.cnf" to set user-specific options.

mysql user?
where need to place this custom config file exacly?
any idea?

best regards