ravensys/mysql repository overview

⁠MySQL 5.7 SQL database server Docker image

This container image includes MySQL database server version 5.7 based on CentOS.

The CentOS image is available on Docker Hub⁠ as ravensys/mysql:5.7-centos7.

⁠Description

This container image provides a containerized packaging of the MySQL mysqld daemon and client application. The mysqld server daemon accepts connections from clients and provides access to content from MySQL databases on behalf of the clients. You can find more information on the MySQL project from the project Web site (https://www.mysql.org/⁠).

⁠Usage

If the database data directory is not initialized, the entrypoint script will first run mysqld --initialize-insecure and setup necessary database users and password. After database is initialized, or if it was already present, mysqld is executed and will run as PID 1.

• Simple user with database

  This will create a container named mysql_database running MySQL with database named db and user with credentials user:pass. Port 3306 will be exposed and mapped to host.

  $ docker run -d --name mysql_database -e MYSQL_USER=user -e MYSQL_PASSWORD=pass -e MYSQL_DATABASE=db -p 3306:3306 ravensys/mysql:5.7-centos7
  

  Copy

• Simple user without database

  This will create a container named mysql_database running MySQL with user with credentials user:pass and admin with credentials root:rootpass. Port 3306 will be exposed and mapped to host.

  $ docker run -d --name mysql_database -e MYSQL_USER=user -e MYSQL_PASSWORD=pass -e MYSQL_ADMIN_PASSWORD=rootpass -p 3306:3306 ravensys/mysql:5.7-centos7
  

  Copy

• Only admin account

  This will create a container named mysql_database running MySQL with admin with credentials root:rootpass. Port 3306 will be exposed and mapped to host.

  $ docker run -d --name mysql_database -e MYSQL_ADMIN_PASSWORD=rootpass -p 3306:3306 ravensys/mysql:5.7-centos7
  

  Copy

  Alternatively the same configuration can be achieved by setting MYSQL_USER environment variable to root.

  $ docker run -d --name mysql_database -e MYSQL_USER=root -e MYSQL_PASSWORD=rootpass -p 3306:3306 ravensys/mysql:5.7-centos7
  

  Copy

To make database data persistent across container executions add -v /host/db/path:/var/lib/mysql/data argument to the Docker run command.

To stop detached container simply run docker stop mysql_database.

⁠Environment variables

The image recognizes following environment variables which can be set during initialization by passing -e VAR=VALUE to the Docker run command.

Following environment variables influence MySQL configuration file. They are all OPTIONAL.

⁠Secrets

The image recognizes following secrets which can be created by running echo <value> | docker secret create <name>.

Default secret name can be changed by setting respective environment variable during initialization, value represents a relative path to a file located in secrets volume.

Notice: Secrets takes precedence over environment variables, if both secret and environment variable are set, the value from secret is used.

⁠Volumes

The following mount points can be set by passing -v /host/path:/container/path to the Docker run command.

Notice: When mounting a directory from host into container, ensure that the mounted directory has appropriate permissions and that owner and group of directory matches UID of user running inside container.

⁠MySQL auto-tuning

When MySQL image is run with the --memory parameter set and if there are no values provided for these environment variables, their values will be automatically calculated based on available memory.

⁠MySQL admin account

The admin account root has no password set by default, only allowing local connections. To allow root user login remotely the MYSQL_ADMIN_PASSWORD environment variable must be set when initializing container. Local connections will still not require password.

⁠MySQL unprivileged account

The unprivileged user account with MYSQL_USER name is created, authenticated by password set in MYSQL_PASSWORD, with all privileges to database MYSQL_DATABASE.

⁠Changing passwords

Since passwords are part of the image configuration, the only supported method to change passwords for database user (MYSQL_USER) and admin root is by changing environment variables MYSQL_PASSWORD and MYSQL_ADMIN_PASSWORD, respectively.

Changing these database passwords through SQL statements or any way other than through environment variables aforementioned will cause a mismatch between values stored in variables and actual passwords. Whenever a database container stars it will reset passwords to values stored in environment variables.

⁠Post-initialization scripts

Image initialization process can by extended by placing sourcable shell scripts, these must have a .sh extension, into post-initialization drop-in /usr/share/container-entrypoint/mysql/post-init.d directory.

• Mount volume with post-init scripts

  To propagate post-initialization scripts from host into container add volume mount -v /path/to/post-init/scripts:/usr/share/container-entrypoint/mysql/post-init.d argument to the Docker run command.

  $ docker run -d --name mysql_database -v /path/to/post-init/scripts:/usr/share/container-entrypoint/mysql/post-init.d -e MYSQL_ADMIN_PASSWORD=rootpass -p 3306:3306 ravensys/mysql:5.7-centos7
  

  Copy

• Extend image with post-init scripts

  This Dockerfile will create a Docker image based on ravensys/mysql:5.7-centos7 with built-in post-initialization scripts from directory post-init-scripts.

  FROM ravensys/mysql:5.7-centos7
  
  COPY post-init-scripts /usr/share/container-entrypoint/mysql/post-init.d
  

  Copy

⁠Changing default locale

This Dockerfile will create a Docker image based on ravensys/mysql:5.7-centos7 with default locale set to de_DE.UTF-8.

FROM ravensys/mysql:5.7-centos7

RUN localedef -f UTF-8 -i de_DE de_DE.UTF-8
ENV LANG de_DE.UTF-8

⁠Troubleshooting

The container initialization scripts and mysqld daemon logs to the standard output, so these are available in container log. This log can be examined by running:

$ docker logs <container>

⁠See also

Dockerfile and other sources for this container image are available on https://github.com/ravensys/container-mysql⁠.