Setup MySQL 5.5 or 5.6 on Docker on OS X

Docker install link https://docs.docker.com/docker-for-mac/install/#what-to-know-before-you-install use Get Docker for Mac (Stable)

After you install Docker check if Docker is installed correctly by running command

 $ docker --version (You will get the docker version number)

To install MySQL v5.5 on Docker run the following commands. The following will install a Docker container called dock-mysql run

$ docker pull mysql:5.5
$ docker run --name dock-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=<your password> -d mysql/mysql-server:5.5

To install MySQL v5.6 on Docker run the following commands. The following will install a Docker container called dock-mysql run

$ docker pull mysql:5.6
$ docker run --name dock-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=<your password> -d mysql/mysql-server:5.6

Command to check if MySQL docker instance is running

$ docker ps -a

Command to stop MySQL docker instance

$ docker stop dock-mysql

Command to start MySQL docker instance

$ docker start dock-mysql

Command to login to MySQL docker instance

$ docker exec -it dock-mysql bash

This takes you to Docker instance terminal

Now setup a remote MySQL user called user1 to connect to Docker

BASH-4.2# mysql -uroot -p
bash-4.2# CREATE USER ‘user1’@‘%’ IDENTIFIED BY ‘<your password>’;
bash-4.2# GRANT ALL PRIVILEGES ON *.* TO ‘user1’@‘%’;
bash-4.2# FLUSH PRIVILEGES;

Connect to Docker MySQL instance

Host: 127.0.0.1 or localhost
Port: 3306
User: user1