MySQL Docker

From Dogtag
Revision as of 04:10, 20 September 2022 by Edewata (talk | contribs) (References)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Pulling Docker Image

$ docker pull mysql

Running MySQL Server

To run MySQL server in background:

$ docker run \
 --name mysql-server \
 --privileged \
 -e MYSQL_ROOT_PASSWORD=Secret.123 \
 -v $PWD/data:/mnt/data \
 -d \
 mysql

The above command maps $PWD/data into /mnt/data to allow container to access files on the host machine.

To access the container:

$ docker exec -ti mysql-server bash

Running MySQL Client

To run MySQL client within MySQL server container:

$ docker exec -ti mysql-server mysql -h 127.0.0.1 -u root -p

To run generic client in a separate container linked to the MySQL server container:

$ docker run --link mysql-server:mysql <command>

The client container will have environment variables which can be used to connect to the MySQL server:

  • MYSQL_ENV_MYSQL_ROOT_PASSWORD=Secret.123
  • MYSQL_ENV_MYSQL_MAJOR=5.5
  • MYSQL_ENV_MYSQL_VERSION=5.5.58
  • MYSQL_ENV_GOSU_VERSION=1.7
  • MYSQL_NAME=/vibrant_euler/mysql
  • MYSQL_PORT_3306_TCP_PROTO=tcp
  • MYSQL_PORT=tcp://172.17.0.2:3306
  • MYSQL_PORT_3306_TCP=tcp://172.17.0.2:3306
  • MYSQL_PORT_3306_TCP_PORT=3306
  • MYSQL_PORT_3306_TCP_ADDR=172.17.0.2

To run MySQL client in a separate container linked to the MySQL server container:

$ docker run -it --link mysql-server:mysql --rm mysql \
  sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'

Note: there are no spaces after -h, -P, -u, and -p in the above command.

Creating Database

To create database:

$ docker exec -ti mysql-server \
 mysql -h 127.0.0.1 --password=Secret.123 -e "create database <name>"

To import a file stored in $PWD/data:

$ docker exec -ti mysql-server \
 mysql <name> -h 127.0.0.1 --password=Secret.123 -e "source /mnt/data/$FILENAME"

See Also