dhi.io/mysql
MySQL is a widely used, open-source relational database management system (RDBMS).
All examples in this guide use the public image. If you've mirrored the repository for your own use (for example, to your Docker Hub namespace), update your commands to reference the mirrored image instead of the public one.
For example:
dhi.io/<repository>:<tag><your-namespace>/dhi-<repository>:<tag>For the examples, you must first use docker login dhi.io to authenticate to the registry to pull the images.
Run the following command to run a MySQL container. Replace <tag> with the image variant you want to run.
$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d dhi.io/mysql:<tag> mysqld
Note: Unlike the official MySQL image, you must explicitly pass mysqld as the command to start the MySQL server.
Run the MySQL command line client against your container:
$ docker exec -it some-mysql mysql -uroot -p
Example compose.yaml for MySQL:
services:
db:
image: dhi.io/mysql:<tag>
restart: always
environment:
MYSQL_ROOT_PASSWORD: my-secret-pw
command: mysqld
volumes:
- mysql-data:/var/lib/mysql
volumes:
mysql-data:
The MySQL image uses the following environment variables for configuration. These variables only take effect when initializing a new database. If you start the container with a data directory that already contains a database, these variables are ignored.
| Variable | Description |
|---|---|
MYSQL_ROOT_PASSWORD | Sets the password for the MySQL root superuser account. This variable is required unless MYSQL_ROOT_PASSWORD_FILE is used. |
| Variable | Description |
|---|---|
MYSQL_ROOT_PASSWORD_FILE | Path to a file containing the root password. Use this instead of MYSQL_ROOT_PASSWORD for Docker secrets. |
MYSQL_OPTIONS | Additional command-line options to pass to mysqld (space-separated). For example: --max-connections=50. |
| Variable | Description |
|---|---|
MYSQLDATA | Path to the MySQL data directory. Defaults to /var/lib/mysql. Do not override this value. |
You can load the MySQL root password from a file using the MYSQL_ROOT_PASSWORD_FILE environment variable. This is
useful for Docker secrets and other secret management systems.
Using Docker Compose with secrets:
services:
mysql:
image: dhi.io/mysql:<tag>
secrets:
- mysql_password
environment:
MYSQL_ROOT_PASSWORD_FILE: /run/secrets/mysql_password
command: mysqld
secrets:
mysql_password:
file: ./mysql-password.txt
Using Docker run with a mounted file:
$ docker run --name some-mysql \
-e MYSQL_ROOT_PASSWORD_FILE=/run/secrets/mysql_password \
-v /path/to/password-file:/run/secrets/mysql_password:ro \
-d dhi.io/mysql:<tag> mysqld
Note:MYSQL_ROOT_PASSWORD and MYSQL_ROOT_PASSWORD_FILE are mutually exclusive. If both are set, the container
exits with an error.
Use the MYSQL_OPTIONS environment variable to pass additional options to the MySQL server:
$ docker run --name some-mysql \
-e MYSQL_ROOT_PASSWORD=my-secret-pw \
-e MYSQL_OPTIONS="--max-connections=50 --thread-cache-size=16" \
-d dhi.io/mysql:<tag> mysqld
Alternatively, pass options directly on the command line after mysqld:
$ docker run --name some-mysql \
-e MYSQL_ROOT_PASSWORD=my-secret-pw \
-d dhi.io/mysql:<tag> mysqld --max-connections=50
The Docker Hardened MySQL image has a simplified entrypoint focused on security and minimal attack surface. The following features from the official MySQL image are not supported:
| Feature | Official image | DHI image | Notes |
|---|---|---|---|
MYSQL_DATABASE | ✅ | ❌ | Create databases manually after startup |
MYSQL_USER / MYSQL_PASSWORD | ✅ | ❌ | Create users manually after startup |
MYSQL_ALLOW_EMPTY_PASSWORD | ✅ | ❌ | Root password is always required for security |
MYSQL_RANDOM_ROOT_PASSWORD | ✅ | ❌ | Generate passwords externally and pass via env var or file |
MYSQL_ONETIME_PASSWORD | ✅ | ❌ | Manage password expiration manually |
MYSQL_INITDB_SKIP_TZINFO | ✅ | ❌ | Timezone data is not loaded by default |
/docker-entrypoint-initdb.d scripts | ✅ | ❌ | Run initialization scripts manually after startup |
Implicit mysqld command | ✅ | ❌ | Must explicitly pass mysqld as the command |
Since the DHI image does not support automatic database/user creation, create them manually after the container starts:
# Create a database
$ docker exec -it some-mysql mysql -uroot -p -e "CREATE DATABASE mydb;"
# Create a user with privileges
$ docker exec -it some-mysql mysql -uroot -p -e \
"CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypassword'; \
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%';"
To run SQL scripts on container startup, execute them after the container is ready:
# Start the container
$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d dhi.io/mysql:<tag> mysqld
# Wait for MySQL to be ready, then run scripts
$ docker exec -i some-mysql mysql -uroot -pmy-secret-pw < /path/to/init.sql
Mount a volume to persist MySQL data across container restarts:
$ docker run --name some-mysql \
-e MYSQL_ROOT_PASSWORD=my-secret-pw \
-v mysql-data:/var/lib/mysql \
-d dhi.io/mysql:<tag> mysqld
The MySQL data is stored in /var/lib/mysql inside the container.
Use mysqldump to create backups:
$ docker exec some-mysql mysqldump -uroot -p"$MYSQL_ROOT_PASSWORD" --all-databases > backup.sql
Restore a database from a SQL dump:
$ docker exec -i some-mysql mysql -uroot -p"$MYSQL_ROOT_PASSWORD" < backup.sql
Docker Hardened Images come in different variants depending on their intended use.
Runtime variants are designed to run your application in production. These images are intended to be used either
directly or as the FROM image in the final stage of a multi-stage build. These images typically:
Build-time variants typically include dev in the variant name and are intended for use in the first stage of a
multi-stage Dockerfile. These images typically:
To migrate your application to a Docker Hardened Image, you must update your Dockerfile. At minimum, you must update the base image in your existing Dockerfile to a Docker Hardened Image. This and a few other common changes are listed in the following table of migration notes.
| Item | Migration note |
|---|---|
| Base image | Replace your base images in your Dockerfile with a Docker Hardened Image. |
| Package management | Non-dev images, intended for runtime, don't contain package managers. Use package managers only in images with a dev tag. |
| Non-root user | By default, non-dev images, intended for runtime, run as the nonroot user. Ensure that necessary files and directories are accessible to the nonroot user. |
| Multi-stage build | Utilize images with a dev tag for build stages and non-dev images for runtime. For binary executables, use a static image for runtime. |
| TLS certificates | Docker Hardened Images contain standard TLS certificates by default. There is no need to install TLS certificates. |
| Ports | Non-dev hardened images run as a nonroot user by default. As a result, applications in these images can’t bind to privileged ports (below 1024) when running in Kubernetes or in Docker Engine versions older than 20.10. To avoid issues, configure your application to listen on port 1025 or higher inside the container. |
| Entry point | Docker Hardened Images may have different entry points than images such as Docker Official Images. Inspect entry points for Docker Hardened Images and update your Dockerfile if necessary. |
| No shell | By default, non-dev images, intended for runtime, don't contain a shell. Use dev images in build stages to run shell commands and then copy artifacts to the runtime stage. |
The following steps outline the general migration process.
Find hardened images for your app.
A hardened image may have several variants. Inspect the image tags and find the image variant that meets your needs.
Update the base image in your Dockerfile.
Update the base image in your application's Dockerfile to the hardened image you found in the previous step. For
framework images, this is typically going to be an image tagged as dev because it has the tools needed to install
packages and dependencies.
For multi-stage Dockerfiles, update the runtime image in your Dockerfile.
To ensure that your final image is as minimal as possible, you should use a multi-stage build. All stages in your
Dockerfile should use a hardened image. While intermediary stages will typically use images tagged as dev, your
final runtime stage should use a non-dev image variant.
Install additional packages
Docker Hardened Images contain minimal packages in order to reduce the potential attack surface. You may need to install additional packages in your Dockerfile. Inspect the image variants to identify which packages are already installed.
Only images tagged as dev typically have package managers. You should use a multi-stage Dockerfile to install the
packages. Install the packages in the build stage that uses a dev image. Then, if needed, copy any necessary
artifacts to the runtime stage that uses a non-dev image.
For Alpine-based images, you can use apk to install packages. For Debian-based images, you can use apt-get to
install packages.
The following are common issues that you may encounter during migration.
The hardened images intended for runtime don't contain a shell nor any tools for debugging. The recommended method for debugging applications built with Docker Hardened Images is to use Docker Debug to attach to these containers. Docker Debug provides a shell, common debugging tools, and lets you install other tools in an ephemeral, writable layer that only exists during the debugging session.
By default image variants intended for runtime, run as the nonroot user. Ensure that necessary files and directories are accessible to the nonroot user. You may need to copy files to different directories or change permissions so your application running as the nonroot user can access them.
Non-dev hardened images run as a nonroot user by default. As a result, applications in these images can't bind to
privileged ports (below 1024) when running in Kubernetes or in Docker Engine versions older than 20.10. To avoid issues,
configure your application to listen on port 1025 or higher inside the container, even if you map it to a lower port on
the host. For example, docker run -p 80:8080 my-image will work because the port inside the container is 8080, and
docker run -p 80:81 my-image won't work because the port inside the container is 81.
By default, image variants intended for runtime don't contain a shell. Use dev images in build stages to run shell
commands and then copy any necessary artifacts into the runtime stage. In addition, use Docker Debug to debug containers
with no shell.
Docker Hardened Images may have different entry points than images such as Docker Official Images. Use docker inspect
to inspect entry points for Docker Hardened Images and update your Dockerfile if necessary.