This is an simple example to create a mysql server with docker
1.- create docker-compose.yml:
Note: If you want to use same container for all your projects, you should create a PATH in your HOME_PATH. If you want to create it for every project you could create a docker directory in your project.
version: '2'
services:
cabin_db:
image: mysql:latest
volumes:
- "./.mysql-data/db:/var/lib/mysql"
restart: always
ports:
- 3306:3306
environment:
MYSQL_ROOT_PASSWORD: rootpw
MYSQL_DATABASE: cabin
MYSQL_USER: cabin
MYSQL_PASSWORD: cabinpw
2.- run it:
cd PATH_TO_DOCKER-COMPOSE.YML
docker-compose up -d
3.- connect to server
mysql -h 127.0.0.1 -u root -P 3306 -p rootpw
Hurray!!
4.- stop server
docker-compose stop