setting system variables in MySQL running as docker container

I have used docker to setup mysql server taken from https://registry.hub.docker.com/_/mysql/ , I know that we can set up environment variables using several options while running an image as”-e , -env or –env-file” which works absolutely fine as I want. But now I want to edit my system variables for MySQL say “max_connections=300”. Is there a way we can use these options to achieve this. I have tried using –env-file option to update system variables but no success 🙁 would be really very helpful if anyone can give pointers on this.

Thanks,
~yash

  • Get cpu usage from Java API 1.13 for docker 1.1.2
  • How to mount volume mounted in a docker image into another docker image?
  • link_to strips port from site hosted in container
  • Docker mysql mounted logs directory always empty
  • JFrog artifactory docker image size trough REST
  • Create a remote private registry
  • Limit the number of exited containers on a host (1.8.3)
  • Ionic in docker: Error: Please install Android target: “android-23”
  • Start node app when running docker container from cli
  • Yesod scaffolded site browserId TlsException
  • Celery tasks for different python app in different Docker containers
  • How to auto scale docker containers in a regular cloud server?
  • 2 Solutions collect form web for “setting system variables in MySQL running as docker container”

    Have a look at, for example https://github.com/skarllot/docker-mysql/blob/master/assets/my.cnf.template for a specific value for max_connections, and for the Dockerfile https://github.com/skarllot/docker-mysql

    From description of mysql docker container:

    You can pass arbitrary command line options to the MySQL server by appending them to the run command:

    docker run –name my-container-name -d mysql/mysql-server –option1=value –option2=value
    In this case, the values of option1 and option2 will be passed directly to the server when it is started. The following command will for instance start your container with UTF-8 as the default setting for character set and collation for all databases in MySQL:

    docker run –name my-container-name -d mysql/mysql-server –character-set-server=utf8 –collation-server=utf8_general_ci

    Docker will be the best open platform for developers and sysadmins to build, ship, and run distributed applications.