Subscribe

Mac installing MySQL

✍️

Learn how to install and connect to MySQL on your Mac

4 Jan, 2021 Β· 2 min read

In this article, I’ll guide you through the MySQL installation process on a Mac.

It’s a 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.

You’ll get an annoying screen if you click the download button because they want you to sign up. 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 you’ll find the pkg file there.

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 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 can 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

Spread the knowledge with fellow developers on Twitter
Tweet this tip
Powered by Webmentions - Learn more

Read next πŸ“–

Thank you, Apple, for hijacking port 5000 😣

3 Dec, 2021 Β· 2 min read

Thank you, Apple, for hijacking port 5000 😣

Streaming desktop sound and microphone on Mac with Streamlabs

25 Nov, 2021 Β· 2 min read

Streaming desktop sound and microphone on Mac with Streamlabs

Join 2097 devs and subscribe to my newsletter