sudo vim /etc/mysql/my.cnf
lower_case_table_names=1
[mysqld]
#
# * Basic Settings
#
lower_case_table_names=1
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
sudo service mysql restart
Thank for sharing, although this doesn't work with MySQL 8.
https://bugs.mysql.com/bug.php?id=90695
A workaround is suggested here but be careful.
https://stackoverflow.com/questions/53103588/lower-case-table-names-1-on-ubuntu-18-04-doesnt-let-mysql-to-start/53175727#53175727
Best solution so far to initialize MySQL data directory with the lower_case_table_names=1
https://stackoverflow.com/a/63141850/1084568