Why is Homebrew running MySQL service as root and how to change it?
3
votes
1
answer
3758
views
I used
brew update
brew upgrade mysql
to bump version from 8.0.23 to 8.0.26 and now MySQL service won't start anymore. I try brew services start mysql
and after few seconds the service status goes back to stopped. The last line in .err files in /usr/local/var/mysql
says
[ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
And when I delete the .err files they come back as owned by root. They were not owned by root before.
My current user is not root
and I do not use sudo
to run these commands. Why is this happening and how do I fix it?
Asked by jva
(161 rep)
Aug 12, 2021, 07:16 AM
Last activity: Jun 24, 2023, 02:26 AM
Last activity: Jun 24, 2023, 02:26 AM