I want set lower-case-table-names=1 just for one account in my VPS, is there any way for that?
I try ~/.my.cnf:
[mysqld]
lower_case_table_names = 1
and
lower_case_table_names = 1
but when I try check it, I get this error:
xxx# /scripts/check_users_my_cnf
The file '/home/xxx/.my.cnf' is invalid:
1
1
Successfully unlinked '/home/xxx/.my.cnf'.
what is the problem in /home/xxx/.my.cnf