1

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
1

I solved like this:

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

  2. Install MySQL with Download do MySQL community server

https://dev.mysql.com/downloads/mysql/

And Done! Successfully!

You must log in to answer this question.

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