Install MySQL 8 in MacOS

Assalamualaikum / Hi,

This time I will show you how to install latest MySQL 8 in your MacOS.

Backup & Clean Up

Backup your database first, then run the following command to uninstall MySQL.

Clean up data directory — since you already have backup previously.

Then you also need to remove / backup your my.cnf, since there’s few thing that the configuration is not used anymore, I received the following error.

If you not sure where your my.cnf, use the following command:

Installation

Then install new MySQL 8 via Homebrew:

Once you are done, start the MySQL service:

Now you should be able to have MySQL 8 started:

Authentication

There’s an issue to authenticate, where I did received the following error:

Open up my.cnf — mine located at /usr/local/etc/my.cnf

Add the following at the end of the file:

Save and exit.

Next, you need to login via terminal:

Then run the following command to update the root password:

Now you should be able to login to your MySQL 8 via your MySQL Client.

Sequel Pro

If you are using Sequel Pro as your MySQL Client, you may want to use the test builds — because the stable version keep on crashing, all the time.

Related posts:

Perkenalkan nama saya Alam. Saya adalah mahasiswa semester 5 jurusan Teknik Informatika. Selama hampir 2 tahun saya belajar di bangku pendidikan tinggi saya sama sekali belum menemukan jawaban dari…

Lots of content this month. I’m conscious that a lot of information gets lost in the noise of the world so I’ll try and collate content I release and find useful. This is October 2018 If you want to…

Are you worried about the health of your fingernails? Do they look dirty, yellow and unattractive? This is a common problem, especially for people who work with their hands. Nail polish, dirt and…