mysql - 找不到“./mysql/user.MYD”(错误代码 : 13 - Permission denied)

Question

我正在尝试全新安装 Mac OSX LAMP 并运行命令

mysql_secure_installation

我已经输入了 root 密码，现在我遇到这个错误时必须输入一个新密码，有人有这方面的经验吗？

Re-enter new password:
 ... Failed! Error: File './mysql/user.MYD' not found (Errcode: 13 - Permission denied)

Answer 1

请重试通过执行完全删除 mysql:

brew remove mysql
brew cleanup
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/var/mysql
sudo rm -rf /usr/local/mysql*
sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /private/var/db/receipts/*mysql*

然后重新启动计算机以确保所有进程都已被终止。

然后执行这些命令来安装MySQL:

brew update
brew install mysql
unset TMPDIR
mysql_install_db --verbose --user='<your-username>' --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
mysql.server start

这应该可以解决问题。