MySQL Dockerfile

A Dockerfile that produces a Docker Image for MySQL⁠.

MySQL version

The master branch currently hosts MySQL 5.6.

Different versions of MySQL are located at the github repo branches⁠.

Usage

Build the image

To create the image frodenas/mysql, execute the following command on the docker-mysql folder:

$ docker build -t frodenas/mysql .

Run the image

To run the image and bind to host port 3306:

$ docker run -d --name mysql -p 3306:3306 frodenas/mysql

The first time you run your container, a new user admin with all privileges will be created with a random password. To get the password, check the logs of the container by running:

docker logs <CONTAINER_ID>

You will see an output like the following:

========================================================================
MySQL User: "admin"
MySQL Password: "mKHBsVb2i7OrY26K"
========================================================================

Credentials

If you want to preset credentials instead of a random generated ones, you can set the following environment variables:

• MYSQL_USERNAME to set a specific username
• MYSQL_PASSWORD to set a specific password

On this example we will preset our custom username and password:

$ docker run -d \
    --name mysql \
    -p 3306:3306 \
    -e MYSQL_USERNAME=myusername \
    -e MYSQL_PASSWORD=mypassword \
    frodenas/mysql

Databases

If you want to create a database at container's boot time, you can set the following environment variables:

• MYSQL_DBNAME to create a database

On this example we will preset our custom username and password and we will create a database:

$ docker run -d \
    --name mysql \
    -p 3306:3306 \
    -e MYSQL_USERNAME=myusername \
    -e MYSQL_PASSWORD=mypassword \
    -e MYSQL_DBNAME=mydb \
    frodenas/mysql

Persist database data

The MySQL server is configured to store data in the /data directory inside the container. You can map the container's /data volume to a volume on the host so the data becomes independent of the running container:

$ mkdir -p /tmp/mysql
$ docker run -d \
    --name mysql \
    -p 3306:3306 \
    -v /tmp/mysql:/data \
    frodenas/mysql

Copyright

Copyright (c) 2014 Ferran Rodenas. See LICENSE⁠ for details.