什么用户应该在 Mac 上拥有 /usr/local/mysql？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4762543/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What user should own /usr/local/mysql on Mac?
提问by ma11hew28
What should the file owner & group be of /usr/local/mysqland all contained files & directories? MySQL was working fine, but after I did sudo chown -R $USER:staff /usr/localto 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.
文件所有者和组应该属于什么/usr/local/mysql以及所有包含的文件和目录？MySQL 工作正常，但是在我sudo chown -R $USER:staff /usr/local安装Homebrew 之后，MySQL 无法在启动时自动启动，并且在 MySQL 首选项面板上，我收到“警告：/usr/local/mysql/data 目录不属于 ' mysql' 或 '_mysql' 用户”，当我单击“启动 MySQL 服务器”时，它没有连接。
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!
为了解决这个问题，我跑了sudo chown -R _mysql:wheel /usr/local/mysql/data。然后，我关闭并打开了系统偏好设置。警告消失了，当我单击启动 MySQL 服务器时，它启动了！
MySQL seems to be responding fine now, but I just guessed at this solution. Is what I did correct?
MySQL 现在似乎响应良好，但我只是猜到了这个解决方案。我做的对吗？
采纳答案by Hoatzin
Looks valid to me. This is what my mysql folder looks like:
看起来对我有效。这是我的 mysql 文件夹的样子：
drwxr-xr-x 17 root wheel 578 May 7 2010 .
drwxr-xr-x 8 root wheel 272 Jun 11 2010 ..
-rw-r--r-- 1 root wheel 17987 May 7 2010 COPYING
-rw-r--r-- 1 root wheel 5139 May 7 2010 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root wheel 9339 May 7 2010 INSTALL-BINARY
-rw-r--r-- 1 root wheel 62989 May 7 2010 README
drwxr-xr-x 46 root wheel 1564 May 7 2010 bin
drwxr-x--- 15 _mysql wheel 510 Jan 21 08:15 data
drwxr-xr-x 4 root wheel 136 May 7 2010 docs
drwxr-xr-x 34 root wheel 1156 May 7 2010 include
drwxr-xr-x 22 root wheel 748 Jun 3 2010 lib
drwxr-xr-x 4 root wheel 136 May 7 2010 man
drwxr-xr-x 15 root wheel 510 May 7 2010 mysql-test
drwxr-xr-x 3 root wheel 102 May 7 2010 scripts
drwxr-xr-x 35 root wheel 1190 May 7 2010 share
drwxr-xr-x 29 root wheel 986 May 7 2010 sql-bench
drwxr-xr-x 16 root wheel 544 May 7 2010 support-files
How did you install MySQL it if it didn't hook everything up correctly itself?
如果 MySQL 本身没有正确连接所有内容，您如何安装它？
EDIT:and this is the general flavor of the data folder:
编辑：这是数据文件夹的一般风格：
drwxr-x--- 15 _mysql wheel 510 Jan 24 08:15 .
drwxr-xr-x 17 root wheel 578 May 7 2010 ..
-rw-rw---- 1 _mysql wheel 158773 Jan 24 08:16 $USER.local.err
-rw-rw---- 1 _mysql wheel 4 Jan 24 08:15 $USER.local.pid
drwx------ 6 _mysql wheel 204 Jun 16 2010 $SOME_DB_NAME1
drwx------ 6 _mysql wheel 204 Jun 8 2010 $SOME_DB_NAME2
drwx------ 15 _mysql wheel 510 Jan 18 11:23 $SOME_DB_NAME3
drwx------ 12 _mysql wheel 408 Jan 20 14:40 $SOME_DB_NAME4
-rw-rw---- 1 _mysql wheel 5242880 Jan 24 08:15 ib_logfile0
-rw-rw---- 1 _mysql wheel 5242880 Jan 24 08:15 ib_logfile1
-rw-rw---- 1 _mysql wheel 18874368 Jan 21 17:31 ibdata1
drwx------ 85 _mysql wheel 2890 Jun 3 2010 $SOME_DB_NAME5
drwx------ 85 _mysql wheel 2890 Jun 3 2010 $SOME_DB_NAME6
drwxr-x--- 71 _mysql wheel 2414 Jun 3 2010 mysql
drwx------ 21 _mysql wheel 714 Aug 31 17:27 $SOME_DB_NAME7
I don't run Homebrew on my machine, tho, so I dunno if this is of much help as far as that goes.
我不在我的机器上运行 Homebrew，所以我不知道这是否有很大帮助。
回答by Hoatzin
I had the exact same problem and MattDiPasquale's answer worked for me. I had to keep running mysqldall the time to ensure MySQL was running properly. When I looked at MySQL in the System Preferences I realised I had the same error.
我遇到了完全相同的问题，MattDiPasquale 的回答对我有用。我必须一直运行mysqld以确保 MySQL 正常运行。当我在系统偏好设置中查看 MySQL 时，我意识到我有同样的错误。
