Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


mysql what user should own usr local mysql on mac using -'mysql,osx,data,group,file-ownership'


mysql what user should own usr local mysql on mac  using -'mysql,osx,data,group,file-ownership'

What should the file owner & group be of /usr/local/mysql and all contained files & directories? MySQL was working fine, but after I did sudo chown -R $USER:staff /usr/local to install Homebrew, MySQL couldn't automatically start on startup, and on the MySQL Preferences panel, I got "Warning: The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql' user," and when I clicked Start MySQL Server, it didn't connect.

To fix this, I ran sudo chown -R _mysql:wheel /usr/local/mysql/data. Then, I closed & opened System Preferences. The warning went away, and when I clicked Start MySQL Server, it started!

MySQL seems to be responding fine now, but I just guessed at this solution. Is what I did correct?
    

asked Sep 7, 2015 by rajesh
0 votes
6 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...