我一直在谷歌search和反对这个相当长一段时间了。 我之前没有在这个系统上安装过MySQL，只是通过MacPorts安装了5.6版本，并且在安装完端口后运行了sudo mysql_install_db 。 我不能让服务器启动。
为了诊断问题，我试着运行sudo -u _mysql /opt/local/lib/mysql56/bin/mysqld并得到如下的输出…
2013-10-03 21:40:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-10-03 21:40:13 23189 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql56/ is case insensitive 2013-10-03 21:40:13 23189 [Note] Plugin 'FEDERATED' is disabled. /opt/local/lib/mysql56/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied) ... 2013-10-03 21:40:13 7fff7c8c2180 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. ...
当我运行sudo ls -l /opt/local/var/db/mysql56/ ，我看到…
-rw-r--r-- 1 root _mysql 0 Aug 4 15:00 .turd_mysql56-server -rw-rw---- 1 _mysql _mysql 56 Oct 2 23:09 auto.cnf -rw-rw---- 1 _mysql _mysql 50331648 Oct 3 22:50 ib_logfile0 -rw-rw---- 1 _mysql _mysql 50331648 Oct 2 23:09 ib_logfile1 -rw-rw---- 1 _mysql _mysql 12582912 Oct 3 00:10 ibdata1 drwx------ 81 root _mysql 2754 Oct 3 00:10 mysql drwx------ 55 root _mysql 1870 Oct 3 00:10 performance_schema drwx------ 2 root _mysql 68 Oct 3 00:09 test
当我运行sudo ls -l /opt/local/var/db/mysql56/mysql ，我看到…
... -rw-rw---- 1 root _mysql 1024 Oct 3 00:09 plugin.MYI -rw-rw---- 1 root _mysql 8586 Oct 3 00:09 plugin.frm -rw-rw---- 1 root _mysql 0 Oct 3 00:09 proc.MYD ...
我想这是我应该看到的文件的所有权和权限。 有任何想法吗？
以root身份login并执行：
chown -R _mysql:_mysql /opt/local/var/db/mysql56
您以用户_mysql的身份运行mysql，所以_mysql需要具有数据库目录的权限
cd /opt/local/var/db/mysql56/mysql chown -R _mysql mysql performance_schema test