How to change default IP on MySQL using Dockerfile

In the context of using Docker and MySQL, it is generally not advisable to directly set the MySQL IP address within the Dockerfile, as the container's IP address is dynamically assigned by the Docker engine at runtime. However, we can control how the container interacts with the external world and other containers by configuring Docker networks and using appropriate Dockerfile instructions.

Step 1: Create a Docker Network

First, we can create a custom Docker network to facilitate easier management of network communication between containers and container network configurations.

bash
docker network create --subnet=172.18.0.0/16 my_custom_network

Step 2: Write the Dockerfile

In the Dockerfile, we cannot directly set the IP address, but we can configure other related settings such as port mapping and network mode. Here is a basic Dockerfile example using the official MySQL image:

Dockerfile
# Use the official MySQL image
FROM mysql:latest

# Set environment variables, such as default username and password
ENV MYSQL_ROOT_PASSWORD=my-secret-pw

# (Optional) Run any additional scripts or commands
COPY setup.sql /docker-entrypoint-initdb.d/

# Expose port, although this does not change the IP, it relates to how to access this service
EXPOSE 3306

Step 3: Specify Network Settings When Running the Container

When running the MySQL container using the docker run command, you can specify the previously created network and optionally set the container's IP address (if a fixed IP is required).

bash
docker run --name my-mysql-container \
  --net my_custom_network --ip 172.18.0.22 \
  -d mysql:latest

Summary

Through the above steps, we do not directly change the IP address in the Dockerfile; instead, we specify and manage the IP address using Docker's networking features. This approach provides greater flexibility and control, suitable for scenarios with specific network configuration requirements in both development and production environments.

If you need to configure complex networking or service discovery across multiple containers, you may also consider using container orchestration tools like Docker Compose or Kubernetes to manage services. The IP configuration and network communication for each service can be managed more precisely through the configuration files of these tools.