在Mac上，哪个用户应该拥有/usr/local/mysql? [英] What user should own /usr/local/mysql on Mac?

问题描述

文件所有者应如何处理?组的/usr/local/mysql和所有包含的文件&目录? MySQL运行正常，但是在我sudo chown -R $USER:staff /usr/local安装 Homebrew 之后，MySQL无法自动启动在启动时，以及在"MySQL首选项"面板上，我得到警告:/usr/local/mysql/data目录不属于'mysql'或'_mysql'用户，"并且当我单击启动MySQL服务器"时，它没有不连接.

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.

要解决此问题，我运行了sudo chown -R _mysql:wheel /usr/local/mysql/data.然后，我关闭了&打开系统偏好设置.警告消失了，当我单击启动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!

MySQL现在似乎反应良好，但是我只是在猜测这种解决方案.我做对了吗?

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

推荐答案

对我看来有效.这是我的mysql文件夹的样子:

Looks valid to me. This is what my mysql folder looks like:

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

如果MySQL本身无法正确连接所有东西，您如何安装它呢?

How did you install MySQL it if it didn't hook everything up correctly itself?

，这是数据文件夹的一般风格:

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

我没有在我的机器上运行Homebrew，所以我不知道这样做是否有帮助.

I don't run Homebrew on my machine, tho, so I dunno if this is of much help as far as that goes.

这篇关于在Mac上，哪个用户应该拥有/usr/local/mysql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！