Base docker image to run a MySQL database server
Usage
To create the image warrantgroup/mysql, execute the following ;
docker build -t warrantgroup/mysql
To run the image and bind to port 3306:
docker run -d -p 3306:3306 --name mysql warrantgroup/mysql
The first time that you run your container, a new user admin with all privileges
will be created in MySQL with a random password. To get the password, check the logs
of the container by running:
docker logs <CONTAINER_ID>
You can now test your deployment:
mysql -uadmin -p
Setting a specific password for the admin account
If you want to use a preset password instead of a random generated one, you can
set the environment variable MYSQL_PASS to your specific password when running the container:
docker run -d -p 3306:3306 -e MYSQL_PASS="password" warrantgroup/mysql
You can now test your deployment:
mysql -uadmin -p"mypass"
The admin username can also be set via the MYSQL_USER environment variable.
Mounting the database file volume
In order to persist the database data, you can mount a local folder from the host on the container to store the database files. To do so:
docker run -d -v /path/host:/var/lib/mysql warrantgroup/mysql /bin/bash -c "/usr/bin/mysql_install_db"
This will mount the local folder /path/host inside the docker in /var/lib/mysql (where MySQL will store the database files by default). mysql_install_db creates the initial database structure.
Remember that this will mean that your host must have /path/host available when you run your docker image
After this you can start your MySQL image, but this time using /path/host as the database folder:
docker run -d -p 3306:3306 -v /path/host:/var/lib/mysql warrantgroup/mysql