mysql - 无法在 Mac 上启动 MySQL - 权限被拒绝

Question

我正在尝试在 Mac (High Sierra) 上运行通过 HomeBrew 安装的 MySQL，但我总是遇到权限问题和 PID 文件问题。我尝试了在网上找到的数百种可能的解决方案，但无法解决这些问题:

Haline:/ Haline$ mysql.server start
Starting MySQL
./usr/local/Cellar/mysql/8.0.12/bin/mysqld_safe: line 144: /usr/local/var/mysql/Haline.local.err: Permission denied
/usr/local/Cellar/mysql/8.0.12/bin/mysqld_safe: line 144: /usr/local/var/mysql/Haline.local.err: Permission denied
/usr/local/Cellar/mysql/8.0.12/bin/mysqld_safe: line 199: /usr/local/var/mysql/Haline.local.err: Permission denied
/usr/local/Cellar/mysql/8.0.12/bin/mysqld_safe: line 144: /usr/local/var/mysql/Haline.local.err: Permission denied
 ERROR! The server quit without updating PID file (/usr/local/var/mysql/Haline.local.pid).

谁能帮帮我，拜托？

Answer 1

据官方troubleshooting page of Homebrew :

If commands fail with permissions errors, check the permissions of /usr/local’s subdirectories. If you’re unsure what to do, you can run cd /usr/local && sudo chown -R $(whoami) bin etc include lib sbin share var opt Cellar Caskroom Frameworks.

或者，如果您还没有在 /usr/local 中安装依赖特定权限的应用程序，您也可以运行:

sudo chown -R $(whoami) /usr/local/*