You can download it from here, for this one you don't need a specific version. To be able to interact with MySQL Server, we are going to install it's Shell.

Go ahead and install it and remember to copy the password they will give you on the install. Go to the official page and select macOS as your Operating System, after that click on the right side where it seays: 'Looking for previous GA versions?' and select version: 5.7.23 and choose the download type, my preference is DMG Archive. In my case, I'll install also the workbench to administrate my DB, if you have another app, you can skip this one. Installĭepending on your needs, you may want to install more or less.

So we'll install it by downloading it through the website. I went through 2 ways on how to install it: brew and downloading it directly through the website, and the first one (brew) I do not recommend it since gives a lot of problems and it's time consuming to troubleshoot, see the problem with brew here. So in order to work on your local Node.js environment, you will have to have MySQL 5.7 installed. Here's a pull request in pipeline to properly address the issue. Currently, the community Node.js drivers for MySQL don't support compatible client-side authentication mechanisms for the new server plugin. There is an unsolved problem going on between the Node.js and MySQL authentication, the thing is that MySQL 8.0 uses a new default authentication plugin - caching_sha2_password - whereas MySQL 5.7 used a different one - mysql_native_password.

Brew install mysql 5.7