This is because by default MySQL root user uses a new mode of authentication which is not supported by your client. Notably Sequel Pro and node.js mysql package. This is an issue that you might experience with MySQL 8, while connecting with some clients. Authentication plugin ‘caching_sha2_password’ cannot be loaded But for slower models with less RAM running Docker and specifically MySQL in Docker might be inconvenient.Īnd one more thing. This is barely noticeable if you have a relatively performant Mac with at least 16 GB of RAM. This is because under the hood it runs a virtualized Linux OS. It is worth mentioning that Docker on macOS is relatively heavy on resources. The instance is running as long as Docker is running, you can start and stop individual instances from Docker Dashboard. That's it, the instance is up and running. More information on configuration options can be found here. Or if you don't care, you can specify latest to pick whatever latest version is available on Docker Hub at the moment of the container creation. d mysql:latest – here you can specify an exact MySQL version you want to launch. e MYSQL_ROOT_PASSWORD= – this is a password for MySQL root user. If you plan to run multiple MySQL instances, it might be a good idea to attach each to a different port in the range of 33061–33069. It can be anything, including 3306, as long as it is not busy with something else. The port before the colon is the port on your desktop to expose MySQL. MySQL inside the container hangs on the standard port 3306. It should be unique in the scope of your desktop. name – defines a name for a running instance. You might want to alter certain parameters (more on that below).

Create one for your MySQL instance with the following command in the terminal. Create a containerĭocker runs apps in containers. They provide a desktop application with a convenient UI and native means to install it. Installing Docker on macOS is pretty straightforward these days. Here is a short guide on how to get it up and running in no time.

Which is still not supported by another popular option, MAMP. Most importantly they can run different MySQL versions, including version 8. You can have multiple MySQL instances running side by side. It is pretty straightforward to install and use. for development) one of the good ways to do it with Docker. If you need to run MySQL on your Mac (e.g.

How to run mysql on mac