Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.