Linux MySql requires lower-case-table-names for variable lower_case_table_names

[valentinedwv]

Took many builds to finally get this right. Create a file with the proper name (for 5.5 it is lower-case-table-names, even though variable is named lower_case_table_names)

cat $HOME/.my.cnf

[mysqld]
lower-case-table-names = 1

Check

mysql --verbose -e "show variables like 'lower%';" --user=root

--------------
show variables like 'lower%'
--------------
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 1     |
+------------------------+-------+