Docker + MySQL + `lower_case_table_names=1`

build.sh

# Build the base image
docker build -t widen/db .

# Run the container
docker run --name $container_name --net=host \
        -e MYSQL_USER=$mysql_user \
        -e MYSQL_PASSWORD=$mysql_password \
        -e MYSQL_DATABASE=$mysql_database \
        -e MYSQL_ROOT_PASSWORD=$mysql_root_password \
        -d widen/db
 
# Import SQL       
mysql --user=$user --password=$pass --host=$HOST $db  < $sql_dump

Dockerfile

FROM mysql
ADD my.cnf /etc/mysql/my.cnf
CMD ["mysqld", "--datadir=/var/lib/mysql", "--user=mysql"]

my.cnf

[mysqld]
bind-address=0.0.0.0

# http://www.percona.com/blog/2008/05/31/dns-achilles-heel-mysql-installation/
skip_name_resolve

general_log_file        = /var/lib/mysql.log
general_log             = 1

lower_case_table_names  = 1

CentOS 7 use command: --lower_case_table_names=0 works!
Using docker 18.03.1-ce and docker-compose 1.22.0

How to do it in 2022?

docker-compose.yml

services:
  mariadb:
    command: ['mysqld', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci', '--lower_case_table_names=1']
    image: mariadb
    restart: unless-stopped
    ...

docker-compose.yml

services:
  mariadb:
    command: ['mysqld', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci', '--lower_case_table_names=1']
    image: mariadb
    restart: unless-stopped
    ...

Man! man! you saved my ass! have been dealing with this for days with mysql:5.7.22 docker image. did all settings in the my.cnf, and all the config files and it never worked until i tried running the command you kept in the docker compose.

Thanks bro. Chatgpt couldnt help:)