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

If anyone interested, you can pass extra options to deamon like this:

docker run \
  -d \
  -p 3306:3306 \
  mysql:5.6 \
  mysqld --lower_case_table_names=1

How to pass lower_case_table_names=1 to a docker-compose.yml ?

With docker, it seems to depends on your host OS.
On Mac I use --lower_case_table_names=0 . It's strange that is linked to the file system of the host.

mysql:
    container_name: vpdev-mysql
    image: mysql:5.7
    command: --lower_case_table_names=0
    environment:
      - MYSQL_ROOT_PASSWORD=root
    volumes:
      - ./data/initdb.d:/docker-entrypoint-initdb.d
      - ./data/mysql:/var/lib/mysql
    ports:
      - "3308:3306"

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:)