So I had a bit of a look at MAMP and figured it does exactly the same as what I already installed with Homebrew, just in it’s own container. Only it uses MySQL 5.7 – I’m running version 8.
That also ended up being the reason wordpress coudn’t connect to MySQL. MySQL 8 uses sha2 password validation, which WordPress doesn’t seem to support – hence it can’t connect to the database.
There seems to be workarounds on the SQL-server-site of the setup, but I decided to rollback to MySQL 5.7 until I figure out how to get WordPress to support sha2 MySQL login.
Followed this guide to Uninstall MySQL. Then installed [email protected] with Homebrew.
Everything is working great now! :o)