MySQL Docker image: official MySQL Server container

Andrew Dorokhov schedule 1 min read

menu_book Table of Contents

Official image: open_in_new Docker Hub — mysql .

Minimal run:

docker run -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag

Environment variables

MYSQL_ROOT_PASSWORD
MYSQL_DATABASE
MYSQL_USER
MYSQL_PASSWORD

docker-compose

Adding a service to the docker-compose.yml:

db:
    image: mysql:5.7
    restart: always
    environment:
      MYSQL_DATABASE: test
      MYSQL_USER: test
      MYSQL_PASSWORD: test
      MYSQL_RANDOM_ROOT_PASSWORD: '1'
    volumes:
      - db:/var/lib/mysql

Popular mysql versions:

mysql:5.7
mysql:8.0.39
mysql:9.0.1

How to import a dump

Add a volume to the container:

volumes:
  - ./path/to/dump.sql:/dump.sql

Now open a terminal session for this container and type:

 mysql -uwordpress -pwordpress -pwordpress wordpress < /dump.sql

code

Need Help with Development?

Happy to help — reach out via the contacts or go straight to my Upwork profile.

work View Upwork Profile arrow_forward