Change value lower_case_table_names on a running docker container

Question

I have a running docker image with a database where, for some reason, the columns are in camel-case. I have been searching how to change the value of lower_case_table_names to 1.

How can I make this change without having to recreate the docker image?

Answer 1

2 options;

1. Build the container and ADD or COPY a my.cnf file into place with your desired options.
2. Bind mount a config file into the container as part of the run command

I think there’s possibly a 3rd but I’m not in the position to test but you can possibly add startup options to the docker run command e.g.

docker run -d {other necessary options} mysql/mysql-server:latest —lower-case-table-names