Modify the maximum number of mysql connections and configuration files in docker

1. Find the mysql image

docker ps 

2. Enter the mirror mysql image

docker exec -it 05138413c565 /bin/bash

3. Install vim

Because the docker image does not have a vim command, you need to install it manually, or you can use the docker cp command to copy it from the host machine.

apt-get update
apt-get install vim

4. Edit the configuration file

vim /etc/mysql/mysql.conf.d/mysqld.cnf 

Add max_connections=1024 to the file and save and exit

5. Restart the image

docker kill 05138413c565 
docker start 05138413c565

6. Check whether the number of MySQL connections has changed

show variables like '%max_connections%'; 

As shown in the figure, it has become 1024

This is the end of this article about modifying the maximum number of MySQL connections and the implementation of the configuration file in Docker. For more information about modifying the maximum number of MySQL connections in Docker, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!