How to set the lower_case_table_names MySQL variable to 2 ?

Permalink
Apologies, I am new to MySQL and Concrete 5. How can I change this variable?

Here is the error:

"Table names are stored in the lowercase: you may have problems if you plan to move this installation to another server (hint: you should set the lower_case_table_names MySQL variable to 2)"

It also gives a checkbox option that allows you to "ignore warnings"

1 Attachment

 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I assume this is a local install (PC).
If so, go to MySQL and edit the my.ini file.
Find [mysqld] and immediately after add a new line with this 'lower_case_table_names=2' so it looks like this
[mysqld]
lower_case_table_names=2

Restart your server and you should be good to go.