Table of Contents
...
The database server on Linux is case-sensitive with regards to database and table names.
Add below lines line below [mysqld] section:
lower_case_table_names=1
...
A database collation is a set of rules used to compare characters in a character set. We configure collation as 'utf8_unicode_ci' because it supports all character used in the US, Canada, Australia, and Europe (Latin and Greek).
Add below lines under [mysqld] section in my.cnf file:
...