DEV Community

Cover image for Mac installing MySQL
Chris Bongers
Chris Bongers

Posted on • Originally published at daily-dev-tips.com

Mac installing MySQL

In this article, I'll be guiding you through the installation process for MySQL on a Mac.

It's a pretty straightforward installation, and we will need this when setting up our Mac for web development.

Download MySQL for Mac

To install MySQL, we need to visit the MySQL website and pick the download we need.

MySQL download page

For most people, the top DMG archive will work.

If you click the download button you'll get an annoying screen because they want you to signup. Just click the No thanks button at the bottom.

MySQL download page

Installation of the MySQL server

Once the download is done you can click the DMG file and in there you'll find the pkg file.

Double-click this file.

MySQL pkg file

This will open up the installer for MySQL.

MySQL installer Mac

Click Allow on the above step.

Follow all the steps it prompts.

At one stage it asks for the install location, you can go ahead and use the default one.

MySQL install location

After clicking this, you'll be prompted for your password, enter it and the installation begins.

Then you get a configuration screen, you can select the strong password encryption.

It will then ask you to set the default password for the root user.

MySQL set password

Once we set the password the installation is done.

Find the MySQL server on Mac

You can now find your MySQL server by opening the Settings application on your Mac.

Mac Settings -> MySQL

If you click that you have the option to Start and Stop the server.

MySQL start/stop

Connecting to the MySQL server

We can also use graphic tools to connect to this MySQL server.

In my case, I'll be using TablePlus, but any tool will work the same.

Add a new connection using the following settings

  • host: 127.0.0.1
  • user: root
  • password: You choose this in the installation
  • port: 3306 (default)

Then you can test the connection and connect to it.

Mac MySQL Connection

That's it we installed MySQL and are able to connect to it!

Thank you for reading, and let's connect!

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter

Top comments (0)