Installed MySQL 8.0.18 from a dmg file downloaded from the official site. The service won't start when manually started from the new Preferences icon added by the installer. Running sudo /usr/local/mysql/support-files/mysql.server start
dies with this error message:
Starting MySQL .. ERROR! The server quit without updating PID file
I tried setting file and dir ownership of /usr/local/mysql/
to the _mysql
user, and giving write permissions to /usr/local/mysql/data/
as per other answers suggested but that didn't fix the issue.
Edit: Forgot to make clear this is on macOS Catalina, I think this is highly relevant as this version brought revised security policies setting how/if each app can write to disk.