找不到"./mysql/user.MYD"(错误代码:13-权限被拒绝) [英] './mysql/user.MYD' not found (Errcode: 13 - Permission denied)

问题描述

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

I am trying to do a fresh install of Mac OSX LAMP and running the command

mysql_secure_installation

我已经输入了root密码，当我遇到这个错误时，我现在必须输入一个新密码，有人对此有任何经验吗?

I have inputting the root password and I have to now input a new password when I'm hit with this error, has anyone got any experience with this?

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

推荐答案

请尝试通过执行以下操作完全删除mysql:

Please retry to completely remove mysql by executing:

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*

然后重新启动计算机，以确保所有进程都已被杀死.

And then restart your computer to make sure that all the processes have been killed.

然后执行以下命令以安装MySQL:

Then execute these commands to install 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

这应该可以解决问题.

这篇关于找不到"./mysql/user.MYD"(错误代码:13-权限被拒绝)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！