# Mysql dev env

This is a simple mysql development environment. It provides MySQL and PHPMyAdmin as a minimal
docker-compose deployment. both MySQL and PHPMyAdmin are exposed to the host and can be reached from
other applications

## Setup

In order to use the setup, clone this repository. The configuration is done in `.env`. 
If you want a specific database to be created on container initialization, set `MYSQL_DATABASE`. Its
highly recommended to set `MYSQL_ROOT_PASSWORD` to something slightly more secure than `example`,
even its just a local development environment, especially when operating in public networks.

## Database initialisation

Databases can be imported using PHPMyAdmin. Nevertheless it can be useful to automatically load
database dumps on container creation. In order to do this, place arbitrary initialisation scripts in
the subdirectory `initdb.d`. To be executed these files need to have one of the following
extensions:

- `.sh`
- `.sql`
- `.sql.gz`

## Start

Simply run `docker-compose up` to start the services. Run `docker-compose up -d` to run them in
background.

## Reset

To delete the created containers and start again with the initialization, execute `docker-compose
rm`