openeuler/mysql repository overview

⁠Quick reference

• The official MySQL docker image.

• Maintained by: openEuler CloudNative SIG⁠.

• Where to get help: openEuler CloudNative SIG⁠, openEuler⁠.

⁠MySQL | openEuler

Current MySQL docker images are built on the openEuler⁠. This repository is free to use and exempted from per-user rate limits.

Learn more on MySQL website⁠.

⁠Supported tags and respective Dockerfile links

The tag of each mysql docker image is consist of the version of mysql and the version of basic image. The details are as follows

⁠Usage

In this usage, users can select the corresponding {Tag} and container startup options based on their requirements.

• Pull the openeuler/mysql image from docker

  docker pull openeuler/mysql:{Tag}
  

  Copy

• Start a mysql instance

  docker run -d --name my-mysql -p 30306:3306 -e MYSQL_ROOT_PASSWORD=openEuler:S3cr3t/ openeuler/mysql:{Tag}
  

  Copy

  After the instance my-mysql is started, access the mysql service through http://localhost:30306.

• Container startup options

  Option	Description
  -p 30306:3306	Expose MySQL server on localhost:30306.
  -e MYSQL_ROOT_PASSWORD	Set the password for the root user. This option is mandatory and must not be empty.
  -e MYSQL_USER	Create a new user with superuser privileges. This is used in conjunction with MYSQL_PASSWORD.
  -e MYSQL_DATABASE	Set the name of the default database.
  -e MYSQL_ALLOW_EMPTY_PASSWORD=yes	Set up a blank password for the root user. This is not recommended to be used in production, make sure you know what you are doing.
  -e MYSQL_RANDOM_ROOT_PASSWORD=yes	Generate a random initial password for the root user using pwgen. It will be printed in the logs, search for GENERATED ROOT PASSWORD.
  -e MYSQL_ONETIME_PASSWORD=yes	Set root user as experide once initialization is complete, forcing a password change on first login.
  -v /path/to/data:/usr/local/mysql/data/	Persist data instead of initializing a new database every time you launch a new container.
  -v /path/to/config/files/:/usr/local/mysql/mysql.conf.d/	Local configuration files⁠.

• View container running logs

  docker logs -f my-mysql
  

  Copy

• To get an interactive shell

  docker exec -it my-mysql/bin/bash
  

  Copy

⁠Question and answering

If you have any questions or want to use some special features, please submit an issue or a pull request on openeuler-docker-images⁠.