MySQL bind-address in a Docker container

Question

I would like to build a container, which enables bind to multiple IP addresses. Bind address is stored in my.cnf, it is okay. How to define it or maybe comment out with use of a Dockerfile to grant remote access?

Solution

sed is usually the weapon of choice for such tasks. Taken from the official mysql dockerfile:

RUN sed -Ei 's/^(bind-address|log)/#&/' /etc/mysql/my.cnf

The command comments out lines starting with bind-address or log in my.cnf or conf.d/*.