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.

  • Remove /etc/my.cnf or take a backup and restart – Harshal Parekh Oct 30 '19 at 19:39
  • @Harshal Parekh I don't have that file on my system – kaldimar Oct 30 '19 at 20:22

I solved like this:

  1. Remove MySQL completely Watching: https://gist.github.com/vitorbritto/0555879fe4414d18569d

  2. Install MySQL with Download do MySQL community server


And Done! Successfully!

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .