Use % instead of localhost in mysql> CREATE USER IDENTIFIED BY 'password' The root user will not be able to log in from the host OS (Mac OS). Important: This step is required to log into MySQL from outside the container. I create a user named arun, grant all privileges, and quit. After login, the mysql> prompt shows up: bash-4.2# mysql -uarun -ppassword Remember, when we created and ran the MySQL container, we provided MYSQL_ROOT_PASSWORD=password.Ĭreate a database and user, and grant privileges in MySQL (from within the container). Log into MySQL within the docker container using the docker exec command: $docker exec -it mysql bash $docker psĪ3fb00c34877 mysql/mysql-server '/entrypoint.sh my.' 2 minutes ago

You can verify if MySQL has started using the docker ps command below. If the image was not already available, this command will download the image and run it. This will install the latest version of the MySQL image in Docker Hub. $docker run -p 3306:3306 -d -name mysql -e MYSQL_ROOT_PASSWORD=password mysql/mysql-server Run the MySQL image using the docker run command. After installing Docker for Mac, please verify the information below.

Now that we have background info, let's see how to set up MySQL in Docker for Mac.įollow these instructions to install Docker for Mac. Docker for Mac is the fastest and most reliable way to run Docker on a Mac. Docker for Mac is a complete development environment deeply integrated with the MacOS Hypervisor framework, networking, and filesystem. an easy-to-install desktop app for building, debugging, and testing Dockerized apps on a Mac. To simplify Docker and Virtual Machine setup in Mac OS, Docker for Mac was created.Īccording to this documentation, Docker for Mac is: Hence, a Virtual Machine is set up on top of Mac OS and has an instance (Guest OS) of Linux to run containers. Mac OS is Unix and it doesn't have containers directly, as in Linux OS (Ubuntu, Fedora, Core OS, etc.). Why Docker For Mac?ĭocker is an abstraction on top of Linux containers to simplify using and managing containers. This article assumes that you know what Docker is, understand how to use MySQL, and understand how to use SQL commands to create a user, create a database, and grant privileges.īefore we jump into action, let's learn the basics of Docker for Mac. This article will provide step-by-step instructions on how to set up MySQL in Docker for Mac and how to access MySQL from the host (Mac) OS.

Steps to install mysql on mac