Server version: 5.5.49 MySQL Community Server (GPL)Ĭopyright (c) 2000, 2016, Oracle and/or its affiliates. Status: Downloaded newer image for $ mysql -h mysql55 Now if I want to run check MySQL 5.5 for something, I can just do this: $ docker run -name=mysql55 -net=test -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d mysql/mysql-server:5.5 To make this really clean, I added some bash aliases: alias mysqlsh='docker run -it -rm -net=test mysql/shell'Īlias mysql='docker run -it -rm -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -net=test -entrypoint='mysql' mysql/mysql-server:5.7' So, now I want to be able to use the standard MySQL command line and/or the new MySQL shell to access this container.

The shell init uses a temporary container that is removed (–rm) after the run, so you don’t pollute your docker ps - a a output. Notice I didn’t enter a password because I created the server without one (insecure, but it’s a sandbox).

I used the MySQL/shell image (also from Oracle) to initialize the mysqlx plugin on my 5.7 server.

I started a MySQL 5.7 image from Oracle’s official MySQL Docker container bound to that test network.

I like this because multiple containers can listen on the same port and I don’t have to fight with ports on my host OS.

I created a network called “test” for my containers to share, essentially this is a dedicated private network between containers.

The method I used is below: $ docker network create $ docker run -name=mysql57 -net=test -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d $ docker run -it -rm -net=test -e MYSQL_HOST=mysql57 mysql/shell initĮnableXProtocol: Installing plugin mysqlx. Once installed, I needed to setup some Docker containers for common MySQL versions so that I can easily have some sandboxes. I got mine in about a day, but I would assume it won’t be long before the full version is released. The new Docker beta for Mac requires that you register for the beta program, and receive a download code from Docker. These steps work for the beta version on a Mac (and probably Windows), but they should work with Linux as well (using the GA release, currently Docker 1.11.1). However, I saw Giuseppe’s blog on the new Docker beta for Mac and decided to try it for myself.

I’ve been playing with Docker on Mac for a bit, but it is definitely a second-class citizen in the Docker world. The Docker ecosystem seems to be moving quickly, however, and simple “getting started” or “how-to” type articles that are easy to find for well-established technologies seem to be out-of-date or non-existent for Docker.

Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment.

Mysql docker for mac