Posted on Leave a comment

Installing MySQL on macOS with root password reset

Following the recent macOS Mojave update I figured I should update MySQL 5.7.16 to 8.0.something, too. This didn’t work out because of the impossible security hash introduced with it. None of my tools are compatible with it apparently.

After some frustrations and loosing all my databases (Migration/Upgrading also didn’t work) I went back to 5.7. The latest version of MySQL 5.7 is 5.7.24. Easy enough, right? Wrong…
It took me a few hours to figure out. But here is my “first launch” setup guide.

After the installation is complete the MySQL manual sort of tells you you’re done and good luck. What it doesn’t mention however is that the temporary password you get is expired before you even use it. You get your password and as far as I can tell their Password Reset instruction is lacking completeness, too.

Read more »