DEV Community

Cover image for Mac installing MySQL
Chris Bongers
Chris Bongers

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

3

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

Sentry image

Make it make sense

Only the context you need to fix your broken code with Sentry.

Start debugging →

Top comments (0)

Jetbrains image

Build Secure, Ship Fast

Discover best practices to secure CI/CD without slowing down your pipeline.

Read more

👋 Kindness is contagious

Dive into this informative piece, backed by our vibrant DEV Community

Whether you’re a novice or a pro, your perspective enriches our collective insight.

A simple “thank you” can lift someone’s spirits—share your gratitude in the comments!

On DEV, the power of shared knowledge paves a smoother path and tightens our community ties. Found value here? A quick thanks to the author makes a big impact.

Okay