How to edit docker mysql image and increase connection limit

Question

I am new docker concepts. I have mysql image which is already build. I want to increase mysql connection limit to 10000 within configuration file. I researching a lot about this, but I didn't found any clue on this. How can I get mysql configuration file and change settings?

Answer 1

you can run the container like this:

docker run -d -e "MYSQL_ROOT_PASSWORD=test" mysql --max_connections=10000

or make your own Dockerfile:

FROM mysql
CMD [ "--max_connections=10000" ]

then build it:

docker build -t my_mysql .

and run it:

docker run -d -e "MYSQL_ROOT_PASSWORD=test" my_mysql