【Mac MySql异常】Bug 1045 (28000): Access denied to user 'root'@'localhost' on MAC OSX (use password: no) (ERROR 1045 (28000):

时间:2021-09-07 16:46:57   收藏:0   阅读:28

  1、清除本地MySql相关  

  重装Mysql之前先删除本地MySql的相关文件。

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/MySQL*
vim /etc/hostconfig and removed the line MYSQLCOM=-YES-
rm -rf ~/Library/PreferencePanes/MySQL*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*

  也可以直接在设置偏好设置里面执行Uninstall,记得在弹窗中,勾选清楚相关文件

技术分享图片

 

  2、安装MySql  

$ brew services stop mysql
$ pkill mysqld
$ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!
$ brew postinstall mysql
$ brew services restart mysql
$ mysql -uroot

 

原文:https://www.cnblogs.com/xjf125/p/15237435.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!