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"
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"
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
Restart your server and you should be good to go.