Problem

In MySQL 8, it is no longer allowed to change the value of the lower_case_table_names option after the data directory has been initialized.
As the SQL scripts for the database schema creation and queries in the MServer code use the mix of table case name, we can have some problems on these queries.

Resolution

Installing MySQL 8 with Case Insensitive Identifier Names

There are several ways to install MySQL 8 on Linux. The steps that will be shown here are:

1. Install the MySQL repository.
2. Remove previous installations of MySQL or one of its forks.
3. Clean the data directory.
4. Install MySQL 8.
5. Initialize with lower_case_table_names = 1.

The example commands are from Oracle Linux 7 and also works on Red Hat Enterprise Linux (RHEL) 7 and CentOS 7. The MySQL YUM repository will be used. On other Linux distributions the steps will in general be different, but related.

For more details , check the original post below :

https://mysql.wisborg.dk/2019/04/14/install-mysql-...