Running MySQL in a Docker container

Docker

Step 1

Clone the mysql dockerfile repo

git clone https://github.com/docker-library/mysql.git
cd mysql/5.7

Step 2

Create an env file

development.env

MYSQL_ROOT_PASSWORD=mypassword
MYSQL_USER=SvcUser
MYSQL_PASSWORD=myservicepassword
MYSQL_DATABASE=my_service

Step 3

Build and Run the image

docker build .
docker run --name=mysql1 --env-file development.env -p 3306:3306 <image-id>

Connecting to MySQL

Via command line

docker exec -it mysql1 bash
mysql -u SvcUser -pmyservicepassword

Via local machine

mysql -h 127.0.0.1 -u SvcUser -pmyservicepassword

Note: must use 127.0.0.1 and not localhost

Via another local Docker container

ifconfig # find your local ip address

# test that you can connect to your dev machine's ip address
mysql -h 192.168.1.142 -u SvcUser -pmyservicepassword